[PHP] joins issues again

[Steven Macintyre]

 Hi all,

I have the following SQL statement;

SELECT count( salesID ) AS count, branch_name, company_name, branch.branchID
        FROM sales
        LEFT JOIN IGuser ON sales.IGuid = IGuser.IGuid
        LEFT JOIN branch ON IGuser.branchID = branch.branchID
        LEFT JOIN company ON branch.companyID = '{$companyID}'
        WHERE maincompanyid = '{$mcid}'
        GROUP BY branch.branchID
        ORDER BY branch_name ASC

However, i do not want those join records to be appended, only to return the 
count of records from sales.

Can someone assist me with this? I have tried differance variants of joins and 
none of the results are correct.

Sales tbl doesnt have the companyID, nor does IGuser

Regards,

Steven


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php