Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Joining 2 tables (Access 2000)

    My query is made of 2 tables, TblClients and TblOffers. They are joined by ClientID
    and the query shows all the clients who have received an offer.
    There are however clients in the table TblClients who have not received an offer,
    i.e. they have no offerid, and these clients are not shown in the query.
    Can i make a query that shows both types of clients, clients that have an offer
    and a clienta who have no offer?

    My query :

    SELECT TblClients.*, TblOffers.offerid
    FROM TblClients INNER JOIN TblOffers ON TblClients.ClientID = TblOffers.Clientid;

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Joining 2 tables (Access 2000)

    In the query grid, double click the join line between the two tables, and you will see a dialog box asking what type of Join you want. The default only shows value present in both tables. Change it to the one that shows all Clients.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •