Hello,
I have a basic sql statement as listed below:
SELECT Sales_Manager, Plan_ID
FROM SalesTBL
And here is my result set:
Sales_Manager Plan_ID
Martin Stoner 1A
Richard Mark 1A
Melissa Smile 1A
Jacky Fung 2B
Kirk Huge 1A
What I need to do is to return the dataset if Plan_ID listed as 1A only. Above record set has 2B so my return set would be nothing, it has to be all rows with 1A only.
How do I achieve that?
So, as long as the record sets has all rows as 1A then I will return something otherwise nothing, so it has to be all 1A.
Thanks all