Subscriptions aka Jenifer wrote:
query: SELECT tblCustomer.*, tblNotes.note FROM tblCustomer LEFT JOIN tblNotes ON tblCustomer.customerid = tblNotes.noteID WHERE tblCustomer.customerid = 123
You are joining the customerid from the customer table to the noteID from your notes table. You should join with tblNotes.customerID. If most customers have a note, or at least all customers with a small customerid hva notes, this error would manifest in behaviour like you described, as only customers without a note would cause a difference in the integer value of the keys noteid and customerid. Simpler put: it would seem to work until you inserted a customer without a note, and additional customers with notes after that.
-- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]