Try
SELECT Items.ItemID, Stuff.info FROM Items LEFT JOIN Stuff ON
(Items.ItemID = Stuff.ItemID (type=0 || type IS NULL));
Peter Normann
-Original Message-
From: mySQL list [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 17:59
To: [EMAIL PROTECTED]
Subject: A LEFT OUTER JOIN question.
Hi Peter,
Thanks a lot - that does the trick!
Incredibly quick response :)
Ian
-Original Message-
From: Peter Normann [mailto:[EMAIL PROTECTED]]
Sent: 16 June 2002 17:06
To: 'mySQL list'; [EMAIL PROTECTED]
Subject: RE: A LEFT OUTER JOIN question.
Try
SELECT Items.ItemID
: A LEFT OUTER JOIN question.
Hi Peter,
Thanks a lot - that does the trick!
Incredibly quick response :)
Ian
-Original Message-
From: Peter Normann [mailto:[EMAIL PROTECTED]]
Sent: 16 June 2002 17:06
To: 'mySQL list'; [EMAIL PROTECTED]
Subject: RE: A LEFT OUTER JOIN question.
Try