| Cfare ju duhet te dini? |
|
#1
| ||||
| ||||
| 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 |
| Alternativa Teme | |
| Vleresojeni kete Teme | |
|
|
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 |