LEFT JOIN table USING ..

[Scott Hamm]

SELECT 
        associates.shift, 
        concat(associates.firstname,',',associates.lastname) as Operator, 
        mrdaily.kronoshours, 
        mrdaily.pto
LEFT JOIN mrcategories USING
        (
        mrcategories.category='1',
        mrcategories.category='2',
        mrcategories.category='3'
        )

FROM 
        associates, 
        mrdaily
WHERE 
        associates.id=mrdaily.idassociates,
        mrdaily.id=mrentries.idddaily 
AND 
        entrydate='2004-08-03'
ORDER BY 
        associates.shift, 
        associates.lastname, 
        associates.firstname;


What I wanted is to put each category on a column on their own. I seem to
misunderstand the usage of "left join" can anyone help me out here? and do
mysql utilitize as follows in bash:

LEFT JOIN mrcategories USING

        for i in mrcategories.category[MAX],
        do
                mrcategories.category=mrcategories.category[$i]
        done





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]