I have 2 tables with the following columns (other data fields omitted for
I need to return a list of caseid's based on a uid's locationid.
Before executing the query, I only know the uid. I could retrieve the uid's
locationid with a separate query, which would then make getting a list of
FROM profile p
WHERE p.uid = 1
FROM cases c
INNER JOIN profile p ON p.uid = c.uid
WHERE p.locationid = 1
However, for learning and efficiency purposes is there a way to do this ...