Scott,
Perfect. This is exactly what I needed. Is there some place I get
some more documentation on the specifics of the ISO-compatible
queries? Might save me some hair-pulling-out in the future.
See 'Changes in 5.0.12' on the Joins manual page
(http://dev.mysql.com/doc/refman/5.1/en/joi
Perfect. This is exactly what I needed. Is there some place I get
some more documentation on the specifics of the ISO-compatible
queries? Might save me some hair-pulling-out in the future.
Scott
Peter Brawley wrote:
> Scott
>
>>SELECT *
>>FROM UserInfo u, DslInfo d
>>LEFT JOIN DslExtra e ON d.Ds
Scott
>SELECT *
>FROM UserInfo u, DslInfo d
>LEFT JOIN DslExtra e ON d.DslID = e.DslID
>LEFT JOIN ExtraAddr a ON a.UserID = u.UserID
>WHERE u.UserID = d.UserID;
>However it appears this syntax is not valid in MySQL 5.x
Right, as the 5.x docs say, 5.x wants ISO-compatible explicit joins, ie
SEL
I have four tables that I join to get one record set about a
customer. They are: UserInfo, ExtraAddr, DslInfo, and DslExtra.
Specifically the main tables are joined with:
SELECT * FROM UserInfo u, DslInfo d WHERE u.UserID = d.UserID;
I've been adding more data to other tables and LEFT JOINING to
as a matching date; you may or may not want this.
HTH,
Bill
> Subject: Left Join multiple tables
> From: Petre Agenbag <[EMAIL PROTECTED]>
> Date: 29 Jul 2003 16:17:05 +0200
>
> Hi List
> Me again.
>
> I'm trying to return from multiple tables, the records that have
* Petre Agenbag
> I'm trying to return from multiple tables, the records that have field
> "information_sent" between two dates.
> The tables are all related by means of the id of the entry in the main
> table, ie..
>
> main
> identity_name ...
>
> fof
> id_fofid information
Hi List
Me again.
I'm trying to return from multiple tables, the records that have field
"information_sent" between two dates.
The tables are all related by means of the id of the entry in the main
table, ie..
main
id entity_name ...
fof
id_fof id information_sent ...
pub
id_pub
