OK,

I have an ASP page that uses a SQL query to display some data in tables. I am using access 2000 as my db, it has 7 tables in it. In the sql query I am taking data from two tables but I want to have another query that takes data from another table according to the results of the first query. These tables are realeted. Any suggestions?