, 96 MB of RAM,
and a slow IDE HD.)
Henry
-Original Message-
From: Patrick Jacquot [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 13, 2000 5:59 AM
To: [EMAIL PROTECTED]
Subject: Re: [SQL] join if there, blank if not
Henry Lafleur wrote:
> Jacques,
>
> The problem with using th
t; Has anyone examined this problem?
>
> Thanks,
>
> Henry
>
> -Original Message-----
> From: Jacques Williams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 12, 2000 9:41 AM
> To: Gary Stainburn
> Cc: [EMAIL PROTECTED]
> Subject: Re: [SQL] join if there,
Henry Lafleur wrote:
> ...
> What I have always had trouble with, though, is if you have multiple fields
> for a primary key. For example, if a customer master table also had ship-to
> locations as the key and you wanted to get all customers and any orders for
> that customer, in rough ANSI SQL
work if we continue. But how efficiently does this work?
Has anyone examined this problem?
Thanks,
Henry
-Original Message-
From: Jacques Williams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 12, 2000 9:41 AM
To: Gary Stainburn
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] join if there
Gary,
What you want here is an outer join. The syntax would look something like this:
select c.cdate, c.ctime, c.cextn, c.cnumber, n.ndesc
from calls c, numbers n
where c.cnumber=n.nnumber
union all
select null as cdate, null as cextn, null as cnumber, n.nnumber, n.ndesc
from numbers;
(I haven'
Hi all,
I just can't get my head round this one so I hope one of you can.
I've got two tables, one holding phone calls, and another holding phone numbers.
I want to do a select where if the number in the calls table exists
in the numbers table, the description is included otherwise the
descri
