SQL Join Question? - Parajsa Shqiptare Forum

		Parajsa Shqiptare Forum \| Albanian Paradise \| Computers & Internet
SQL Join Question?

SQL Join Question?

LinkBack

Alternativa Teme

Vleresoni Temen

01-08-2007, 10:37

abe l

I/e Sapoardhur

Reg: 01-08-07

Postime: 1

SQL Join Question?

I have 2 tables (TableA and TableB). Can you tell me the difference between:
SELECT * From TableA a JOIN TableB b ON a.ID = b.ID WHERE b.Publish = 'Y' and a.ID > 5

and

SELECT * From TableA a JOIN TableB b ON a.ID = b.ID AND b.Publish = 'Y' WHERE a.ID > 5

I moved the b.Publish to be apart of the JOIN ON expression. Does it make a difference and how?

Tx

__________________
Yahoo! Answers 4ever

Bookmarks

Tags

join, question, sql

« Bad Recovery Disk? | myspace sighn up no workin :(? »

Alternativa Teme
Tregoni Versionin e Pritueshem Dergojeni kete faqe me Email
Vleresojeni kete Teme
Vleresojeni kete Teme:

Rregullore Postimi
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is aktivizuar Buzeqeshjet jane te aktivizuar Kodi [IMG] eshte i aktivizuar Kodi HTML eshte i dizaktivizuar Trackbacks are aktivizuar Pingbacks are aktivizuar Refbacks are aktivizuar

Kapercim Forumesh

Tema te ngjashme
Tema	Filluesi i temes	Forumi	Pergjigje	Postimi i Fundit
I wonder why people in this forum assume that when I ask a critical question I am...	tim w	Guide and Tourism	0	21-09-2007 23:32
Are Greeks xenophobes- question posed by ALBANIA POWER Greeks are xenophobs	tim w	Guide and Tourism	3	18-09-2007 14:40
Question on astral projection...?	Beguiled	Supernatural phenomena	0	06-08-2007 08:54
Follow up question: Religion has its spirits, but paranormal can't!?	advwizard	Supernatural phenomena	1	05-08-2007 05:31
SQL developer license?	rob u	Computers & Internet	0	01-08-2007 07:36

Te gjitha oret jane ne GMT +1. Ora tani eshte 06:52.