Re: How do I???

Article View: borland.public.vdbase.data.sql

Article #1440

Back to borland.public.vdbase.data.sql Previous Next

#1440

From: Bowen Moursund
Date: Wed, 24 Dec 1997 00:00

16 lines
1113 bytes

>I used the Query designer to create a join.  I have a customer file
(parent)
>linked to an invoice file (child) by custID. When I run the query I get
only
>customers with invoices.  I want to see all customers with or without
>invoices. I checked the box on the left side "Include unmatched records"
but
>th result is the same.

What SQL statement is generated? For your purpose, you want a LEFT OUTER
JOIN if the CUSTOMER table is on the left.
____
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm

Technical Details

Message-ID: <67rd8u$k1510@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <67ot62$j2p7@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,d019c265e1ac9a0c
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <supportinfo@borland.com>
Subject: Re: How do I???
Date: 1997/12/24
Message-ID: <67rd8u$k1510@forums.borland.com>
X-Deja-AN: 309926608
Content-Transfer-Encoding: 7bit
References: <67ot62$j2p7@forums.borland.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: DataTech
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message