Try using a JOIN:
SELECT tab1.ID, tab1.Value, tab2.Value
FORM Table1 tab1
JOIN Table2 tab2
ON tab1.ID=tab2.IDInTable1
WHERE tab2.SelectOnThis=666
Without knowing a lot more about your various tables and how they are interconnected, I can;'t give you any exact SQL for your precise need, but that should give you the idea.