I'm trying to create a query whereby I can pick up data based on 2 fields in one table called stock. The scenario is that I have 2 locations, location a and location b and in each location I have a stock of cars. A unique car is based on location and car name.
My query should pick up car names that are only present in both location a and b. I've looked into self join queries, group by queries but can't simply find car names that are only present in both locations.
Question
limok
Hi,
I'm trying to create a query whereby I can pick up data based on 2 fields in one table called stock. The scenario is that I have 2 locations, location a and location b and in each location I have a stock of cars. A unique car is based on location and car name.
My query should pick up car names that are only present in both location a and b. I've looked into self join queries, group by queries but can't simply find car names that are only present in both locations.
Thank you for help!
Link to comment
Share on other sites
9 answers to this question
Recommended Posts