Way to display data of non entry items

I had some problems  in that part.

thanks alot for explaining it well in detail.

Now i know what to do.

Regards

Kinjago1

If you are not familiar with joins, you may want to read these tutorials first.

http://www.w3schools.com/SQl/sql_join_left.asp

http://www.w3schools.com/SQl/sql_join_left.asp

i am struggling to find a way to list those from

my EMPLOYEE table who did not do anything.

What you need here is a JOIN. Specifically an OUTER JOIN, which returns all of the records from one table even when there are no matching records in the other. In your case employees with no sales records.

ie    FROM    EMPLOYEE e LEFT JOIN BKS b ON e.employee_id = b.employee_id

When there is no matching sales record, the BKS employee_id will be NULL.  So to find only employees without sales, use something like:

      SELECT  e.employee_id, OtherColumns ....

      FROM    EMPLOYEE e LEFT JOIN BKS b ON e.employee_id = b.employee_id

      WHERE   b.employee_id IS NULL

SELECT BKS.ID, BKS.employee_id, BKS.Fname, BKS.lname,

One would assume you are already storing the employee's name in the EMPLOYEE table. So good database design dictates the name should not be stored in the BKS table too. As long as you are storing the employee id, you can retrieve the information at any time using a JOIN.

-Leigh

Message was edited by: -==cfSearching==-