I have 2 SQLs and query from two different tables. <BR>In the first SQL, the results are stored in recordset1. <BR>In the second SQL, I want to select the anwser from recordset1. <BR>These are the SQLs I wrote: <BR>SQL1="SELECT Bus_No FROM Est_Bus WHERE Estate_ID=1" <BR>Results are stored in rs1 <BR>SQL2="SELECT Sch_Bus FROM Sch_Bus WHERE Sch_Bus='" & rs1("Bus_No")&"' AND School_ID=1" <BR>But it doesn't work. <BR>Can you give me a solution?