In article <[EMAIL PROTECTED]>,
"Graham Cossey" <[EMAIL PROTECTED]> writes:
> I'm hoping someone can help with a little problem I'm having with a query.
> In the query below I wish to return as least one row per tbl1, however I am
> only getting rows where there is at least an entry for tbl2 :
>
Tom Crimmins
> Interface Specialist
> Pottawattamie County, Iowa
>
> -Original Message-
> From: Graham Cossey
> Sent: Monday, January 31, 2005 5:48 PM
> To: mysql@lists.mysql.com
> Subject: Help with a query using multiple LEFT JOINS
>
> I'm hoping someone can he
want to do the same for tbl4 depending on the behavior you are
looking for.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Graham Cossey
Sent: Monday, January 31, 2005 5:48 PM
To: mysql@lists.mysql.com
Subject: Help with a query using multiple
I'm hoping someone can help with a little problem I'm having with a query.
In the query below I wish to return as least one row per tbl1, however I am
only getting rows where there is at least an entry for tbl2 :
SELECT ...
FROM tbl1 as d
LEFT JOIN tbl2 as r ON d.dcode=r.dcode
LEFT JOIN tbl3 as