If you have two tables you need to query try this example...

<%
Select table1.col1, table1.col2, table2.column1, table2.column2
From table1, table2
Where table1.col1 = table2.column1
%>

or you can do this...

<%
Select table1.col1, table1.col2, table2.column1, table2.column2
From table1
Join table2 on table2.column1 = table1.col1
Where ...
%>