* Andreas Ahlenstorf > I'm having a tricky problem: I've got a database table (PicklistData > with three fields, which I have to use for a join to get the data, > which is associated with them. They are called EAN, ISRC and > LabelProductCode. Until now, there's nothing difficult. But a thing, > which makes the problem insoluble for me: This three fields may be > empty, only one must be filled out (and we can't do anything against > that fact). [snipped details]
I think you need the LEFT JOIN: <URL: http://www.mysql.com/doc/en/JOIN.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]