Re: Help With Syntax

The first table (a) has a list of all my clients. The second table (b) contains all of the clients who have placed orders. <<

The quick answer is to use a LEFT OUTER JOIN or an EXISTS() predicate.


The right answer is to ask why you consider these clients to be
logically diffferent entities. It sounds like what you need is one
table with a status code of some kind to tell you when you have a
client who placed an order versus one who has not (and who returns
orders, etc.).

Why persist redundant data in physical storage? This is called
"attribute splitting" -- you are converting an attribute into a table.

.

Relevant Pages

  • Access2k + SQL 7.0 Lock problem
    ... I have an Access database which has tables linked to SQL Server 7.0 ... Clients ... SummaryMaxDate INNER JOIN ... SummaryMaxDate.ClientKey = Clients.ClientKey LEFT OUTER JOIN ...
    (microsoft.public.access.queries)
  • Re: is there a "does not include" query in Access
    ... You can use the In operator or the EXISTS Clause. ... you can simple use a Left Outer Join like: ... FROM tblClient AS C LEFT JOIN ... > create a report that shows me which clients we have not received work for. ...
    (microsoft.public.access.queries)
  • Re: Reconcilliation
    ... tables doing a left outer join will give u the result ... out if any of the tables are missing records for any of the clients ... > TFees ... > TUsers ...
    (microsoft.public.sqlserver.programming)
  • Re: Newbie: Select records in Table A not in Table B
    ... You use an Outer Join to do this. ... "Terry" wrote in message ... I have another table B of actual clients. ... > potential clients only. ...
    (microsoft.public.access.queries)