Greg Charles wrote:How much do you understand about relational databases and SQL? In this case, there are two tables ... one lists companies and the other lists stores. There is a foreign key to company in store, so that establishes a one company contains many stores relationship. The query finds all the stores belonging to company 2 in state NY. It joins the two tables to do this, though strictly speaking, it doesn't need to.
awesome makes sense! Thank you!