hey,
i have 2 tables
EmployeSales
PriceList
now,im trying to see if an item from EmployeSales
exist in PriceList
but it dosnt give me the right query why?
what i am missing?
this is my code
Code:
SELECT EmployeSales.EmpItem, PriceList.PriceName
FROM EmployeSales INNER JOIN PriceList ON EmployeSales.EmpItem = PriceList.PriceName
Where EmpItem not in (Select EmpItem From PriceList)
GROUP BY EmployeSales.EmpItem, PriceList.PriceName
tnx for any help
salsa