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

    Query in conflict with a table (Access 2000)

    In my query, consisting of 2 tables, customers and orders,i get the employeeid number ordered with a given customer.
    The query is the following :

    SELECT orders.orderid, Customers.Customerid, Customers.EmployeeID
    FROM orders INNER JOIN Customers ON orders.customerid = Customers.Customerid;

    If i add on another table in the query, the tables Employees, then my query
    doesnt show anything.If i remove the table employes from the query, then the query is
    ok again.Obviously the table employees is not convenient for the query. I need the table

    Employees in order to from there the LastName of the
    employee.The tables customers and employees are related one to many, one employee may have many

    customers.
    How do you solve such problems with queries ?

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

    Re: Query in conflict with a table (Access 2000)

    Why would Customers and Employees be related? It would seem more logical if Orders and Employees were related. But try making the join between Customers and Employees into an outer join: double click the line between the tables, and select the option to display all records from Customers.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query in conflict with a table (Access 2000)

    It really woks !! Wonderful !!!!!!
    We I need to assign new orders to the employees in order for the employees to receive bonuss.
    I have solved now my problem

Posting Permissions

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