mysql syntax

[zsxdcfv21]

whats the correct way to write this one :

$q = "SELECT n.BuyerNoteID,
n.Note,
date_format(n.Created, '%d %b %y')
FROM BuyerNote n
LEFT JOIN (Buyer b)
ON (b.BuyerID = n.BuyerID
AND b.BuyerID = '{$_GET['BuyerID']}')
LEFT JOIN (User u)
ON (b.UserID = u.UserID)
";

[Barand]

Do you want to

a ) list buyers even if they have no buyerNote or user records
b ) list buyerNotes even if they have no buyer  or userrecord
c ) list only those where there is a match in buyer and buyerNote but not user tables?

etc etc

In other words, we don't know what is correct if we don't jnow what you want to achieve