g the syntax available but it would be nice to be able to get
them directly
Rhino
- Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "bruno b b magalhães" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Saturday, November 19, 2005 1
magalhães" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Saturday, November 19, 2005 12:05 PM
Subject: Re: BIIG query
At 12:51 -0200 11/19/05, bruno b b magalhães wrote:
Hi guys,
I need some help with an query that I know I must use joins, but
I can't figure out
ROTECTED]>
To: "bruno b b magalhães" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Saturday, November 19, 2005 12:05 PM
Subject: Re: BIIG query
At 12:51 -0200 11/19/05, bruno b b magalhães wrote:
Hi guys,
I need some help with an query that I know I must use joi
uBois" <[EMAIL PROTECTED]>
To: "bruno b b magalhães" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Saturday, November 19, 2005 12:05 PM
Subject: Re: BIIG query
At 12:51 -0200 11/19/05, bruno b b magalhães wrote:
Hi guys,
I need some help with an query that I
Thanks everybody for the help,
Well, I think I wasn't clear as I'd expected. As Rhino said OUTER and
Peter said INNER (he he he).
As far as I can see, seams Rhino understood it better. But I read
some tutorials and tried some combinations, but none worked as I liked.
For example, I starte
At 12:51 -0200 11/19/05, bruno b b magalhães wrote:
Hi guys,
I need some help with an query that I know I
must use joins, but I can't figure out how to.
The problem is, when the contact has an address,
phone and email it works just fine, but I want
it to display those how doesnt also! Could
I don't have time today to answer your question in detail but the basic
technique you need to use is an _OUTER_ join. Those should be completely
compatible for version 4 and above of MySQL.
A regular join, which is usually called an "inner" or "natural" join,
combines rows of tables where the
Bruno,
>when the contact has an address, phone and email it works just fine, but
>I want it to display those how doesnt also! Could someone with JOINs
>experience help me?
Your FROM t1,t2,... WHERE condition1, condition2... joins are INNER, so
they exclude contacts without addresses, phone nu
