List of customers who are not assigned to a salesmanSolution

List of customers who are not assigned to a salesman.

Solution

Write SQL statements to find the following items based on salesman/customer/order table

List of customers who are not assigned to a salesman.

select * from customer c,order o,salesman s where s.salesman_id= c.customer_id and
c.customer_id= o.customer_id and salesman_id is NULL;

if you dont want all the details of all the tables then write it down as below

select c.*,o.* from customer c,order o,salesman s where s.salesman_id= c.customer_id and
c.customer_id= o.customer_id and salesman_id is NULL;