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
ly this information to your specific problem.
Rhino
- Original Message - From: "bruno b b magalhães"
<[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Saturday, November 19, 2005 9:51 AM
Subject: BIIG query
Hi guys,
I need some help with an query that I k
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
QL tutorial should have
some good examples for you, even if it is intended for DB2 or Oracle users.
When you understand the concepts and syntax, you should be able to apply
this information to your specific problem.
Rhino
- Original Message -
From: "bruno b b magalhães" <
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
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 someone with JOINs experience help me?
And one
