[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;




Disillusionment is what little heroes are made of. - Gene Kelly

More information about the thelist mailing list