My SQL Tutorials - Sub Select
Here is some example code to help with your SQL programming.:
Select Column1
From Table1
Where Column2 = "Value1"
and Column3 = "Value2"
and Column1 in
(Select Column1
From Table2
Where Column4 equals "Value3");