select col1,col2 
from table1,table2 
where table1.col1='bob' and table2.col2=table1.col2