Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Burgas, Bulgaria
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    join problems (Access 2000)

    I have a query that shows all the clients who have received an offer.It works excellent,
    it shows even the clients who have turned down the offer and those who have not.

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


    I need now to introduce a third possibility.Namely, to enumerate those clients,who have not been aproached
    and have not received an offer, i.e. those clients where Offerid = 0

    However, my query does not show these clients.If a client has no offer,he is not shown on the query.
    Can i join the tables in a way to show also the clients without an offer ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: join problems (Access 2000)

    Try replacing INNER JOIN by LEFT JOIN. This will make the query return ALL records from TblClients, regardless of whether there is a matching record in TblOffers or not.

Posting Permissions

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