Home » SQL & PL/SQL » SQL & PL/SQL » and or where
and or where [message #207525] Tue, 05 December 2006 21:51 Go to next message
BigLearner
Messages: 10
Registered: December 2006
Junior Member
Hai everyone,

Can someone tell me whats the difference using AND and WHERE in the ansi join.

Its basically used to further filter the query, atleast thats what i suppose.

Can someone comment ?

BigLearner
Re: and or where [message #207587 is a reply to message #207525] Wed, 06 December 2006 02:35 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
WHERE is used for the first clause, and AND is used for each subsequent one.
Re: and or where [message #207590 is a reply to message #207525] Wed, 06 December 2006 02:40 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Didn't Ross explain that to you in another post?
Re: and or where [message #207766 is a reply to message #207590] Wed, 06 December 2006 23:42 Go to previous message
BigLearner
Messages: 10
Registered: December 2006
Junior Member
I see some examples in the book that I have where they use AND or WHERE just immediately after the ON clause.

So, I felt there is something that I couldn't figure out about this.

Sorry if its confusing.

Thanks in advance and for all the other replies.

BigLearner
Previous Topic: how to make stored procedures in ORACLE
Next Topic: Using UTL file Read selected text from text file
Goto Forum:
  


Current Time: Thu Dec 08 18:09:40 CST 2016

Total time taken to generate the page: 0.13497 seconds