zsxdcfv21 Posted August 30, 2006 Share Posted August 30, 2006 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) "; Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2006 Share Posted August 30, 2006 Do you want to a ) list buyers even if they have no buyerNote or user recordsb ) list buyerNotes even if they have no buyer or userrecordc ) list only those where there is a match in buyer and buyerNote but not user tables?etc etcIn other words, we don't know what is correct if we don't jnow what you want to achieve Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.