Querying two tables into an ASP page

[Scuba_Steve]

I have just started using databases and would like to be able to use two tables in my query rather than just one. Currently I have

fp_sQry="SELECT * FROM ""External Jobs"""

This allows me to select the fields I want from that table to show up on my ASP page using this code.

<%=FP_FieldVal(fp_rs,"Title")%>

I want to add a second table into the above query that would allow me to select from another table, still in the same DB. What would I append to the Query to make this happen?

Thank you,

Scuba

[CardboardHammer]

Insufficient info.

My guess is that you're probably going to want to do a JOIN, but it's impossible to say for sure with the info given.

Also, you should specify the columns of interest rather than using * (the exception is when you use COUNT).