ect: RE: 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]
> Subj
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, 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
