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.
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?