On Tue, 19 Nov 2002, Bill Easton wrote:
> I'd be happy to write up a short example for inclusion in the MySQL manual,
> if there were some indication from MySQL, AB, that it would be included.
I guess they will; after all it would fit perfectly into the tutorial and
would be most welcome to all r
"John Ragan" <[EMAIL PROTECTED]>
To: "Bill Easton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 11:19 AM
Subject: Re: MySQL Left Join Query
>
> wow!
>
> that's known as "above and beyond the call of
> du
wow!
that's known as "above and beyond the call of
duty". hope the newbies appreciate your work.
> Here's a mini-tutorial on left join that should solve your problem.
>
> First, let's make a smaller example. (It would have been helpful if
> you had done that and formatted your select so i
Here's a mini-tutorial on left join that should solve your problem.
First, let's make a smaller example. (It would have been helpful if
you had done that and formatted your select so it could be read when
you posted the question ;-) Here are 2 tables:
select * from header;select * f
An update to my earlier post. I'm getting a bit closer but still not there.
In the following query:
select decheader.code, decheader.height, decheader.width,
decplacement.position, decplacement.product
from decheader left join decplacement on decheader.code = decplacement.code
and
(decheader.code