Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    42

    Unanswered: how to build a query

    Can you help me with the construction of a query.I want to make a query out of 2 tables and to show in this query the number of the call and the call
    date.My query shows the number of the call, but it does not show the date.
    Obviously i cannot bind the 2 tables together.
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    The reason it does not show the date is because there is no date entry for that record (the record where ClientID=5). In fact that is the only record with no date!

    Obviously this is an example but make sure you implement primary keys in your tables (if you haven't already). Also the join you have implemented in your query here is unnecessary since you are not getting any more information from tblClients. ClientID is already in CallsClients. However, if you needed to show ClientNAme for example then yes, the joi would be necessary.

    hth
    Chris

Posting Permissions

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