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
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
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!
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
PROTECTED]
To: bruno b b magalhães [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
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
]
To: bruno b b magalhães [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
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
, 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 how to.
The problem is, when the contact has an address, phone and email
it works just
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
mysql@lists.mysql.com
Sent: Saturday, November 19, 2005 12:05 PM
Subject: Re: BIIG