Untitled

how to properly use JOIN?

table xymply_categories

id

name

 

table xymply_categoryf_key

locid

catid

       

SELECT *

FROM `xymply_categoryf_key`, xymply_categories

JOIN `xymply_categories` ON

        xymply_categories.id = xymply_categoryf_key.catid

WHERE locid = 1;

       

SELECT xc.id, xc.name

    FROM xymply_categories xc

        INNER JOIN xymply_categoryf_key xck

            ON xc.id = xck.catid

    WHERE xck.locid = 1;

       

SELECT c.id, c.name FROM xymply_categories c, xymply_categoryf_key k WHERE c.id = k.catid AND k.locid = 1;

       

WHERE c.id = k.catid

       

xymply_categories a JOIN xymply_categories b WHERE a.id = ...

       

select * from xymply_categoryf_key a, xymply_categories b where a.catid = b.id

WHERE b.locid = 1;

       

SELECT xymply_categoryf_key.catid, xymply_categories.name FROM xymply_categories INNER JOIN `xymply_categoryf_key` ON xymply_categories.id = xymply_categoryf_key.catid WHERE xymply_categoryf_key.locid = 1;