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
gt; select header.*, placement.*
> from header
> inner join tt
> on header.code = tt.code
> left join placement
> on tt.code = placement.code
> and tt.product = placement.product;
>
> which also gives the desired result:
> +--+--
| NULL |
|7 |7 | OVRLCKBDG |
+--+--+---+
> From: "Mark Colvin" <[EMAIL PROTECTED]>
> To: "MySQL Mailing List \(E-mail\)" <[EMAIL PROTECTED]>
> Subject: MySQL Left Join Query
> Date: Mon, 18 Nov 2002 08:05:51 -
>
&
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
I have a two table query where I want to return records from the first table
and if they have corresponding details in my second table I wish to return
those as well. A sample sql statement I am using is as follows:
select decheader.code, decheader.height, decheader.width,
decplacement.position, d
I have a two table query where I want to return records from the first table
and if they have corresponding details in my second table I wish to return
those as well. A sample sql statement I am using is as follows:
select decheader.code, decheader.height, decheader.width,
decplacement.position, d
