[thelist] basic SQL question...

[jsWalter]

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