Question Locked

How to use a result from a query to prform another query?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

I have a problem. I trying to create a database for buying pattern analysis. I have a set of table: customer and item. I want to create a query which will display, all the item that were bought by this customer who bought item ID p23541.
Which mean I need to set item ID p23541 as my main that lead to a specific customer and I want to know what else did he bought. So I imagine that I need to query? but can it be done

Thank you

2 replies

by absolutely

Make your query based on item number into a make-table query. Then use a join on the two customer tables to select all items bought by the customers in the newly-made customer table.

This discussion is closed to new replies.