I have 2 tables. Employee and Items. USING MYSQL. Employee Contains emp_id and item and item has only items Items has Pen, Pencil, Book, LCD, Mouse. Employee has 1,Pencil 1,Pen 2,Book 2,LCD
I want the result set having all employees and the items they do not have. The result should be employee wise. and NOT IN OR EXISTS DOESNOT WORK. Like in the above 2 tables the result set should be: 1, Book 1,LCD 1,Mouse 2,Pen 2,Pencil 2,Mouse
