Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Unhappy Unanswered: difficulty setting up query to show employee/client relationship??

    Guys, I'm having a bit of difficulty setting up a database for a friend's business.

    What i need to do is be able to run a query that will tell me what clients an employee is working on at any given time. The only problem I'm really stuck on is that I need to state the Telemarketer, Sales Person, and Demonstrator for each client and these can over lap (with one employee doing both). I'm having trouble with the query - as when i put in as a field for the query i put both/all telemarketer, sales person and demonstrator, it only returns results where the employee in question is working on all three.

    I need to be able to see - regardless of what they are doing, which clients they are working on, probably be good to see what they actually are doing to.

    Please help!

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    please show existing query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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