Querying two tables into an ASP page
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
This allows me to select the fields I want from that table to show up on my ASP page using this code.
fp_sQry="SELECT * FROM ""External Jobs"""
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?
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).
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)