Re: non-constant comparisons in where clauses

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 27 Aug 1998 22:04:13 +0200
Message-ID: <6s4e20$5mt$1@pascal.a2000.nl>

>from v_sales sa, cm

Where is the tablename which gets the alias cm? Just missing in this message I guess (you stated "roughly"...) ? And where is the join for the two tables?

>with exactly the same results.

*What* result? Some error message?

>Are we not allowed to perform this kind of function in
>where clauses?

Hmmm, the where clause seems OK to me.

Arjan. Received on Thu Aug 27 1998 - 15:04:13 CDT

This message: [ Message body ]
Next message: jogray_at_my-dejanews.com: "Oracle security policies"
Previous message: Marc Billiet: "Re: PL/SQL Question - Calling a procedure dynamically"
In reply to: Kevin Skaalrud: "non-constant comparisons in where clauses"
Next in thread: Kevin Skaalrud: "Re: non-constant comparisons in where clauses"
Reply: Kevin Skaalrud: "Re: non-constant comparisons in where clauses"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US