[thelist] basic SQL question...
jsWalter
jsWalter at torres.ws
Fri Aug 22 22:51:40 CDT 2003
Can you tell me why 'A' is better or worse than 'B' ?
Just trying to find out what is best to use and when.
SQL sample 'A'
SELECT *
FROM img_items, img_cat
WHERE img_id = 20
AND img_items.cat_id = img_cat.cat_id;
SQL sample 'B'
SELECT *
FROM img_items
NATURAL JOIN img_cat
WHERE img_items.img_id = 20;
Thanks
Walter
======================================================================
Disillusionment is what little heroes are made of. - Gene Kelly
More information about the thelist
mailing list