>i want to know the proper syntax for selecting multiple table in ADO, say i have 7 tables that i want to retrieve data from using the data i retrieved from the first recordset
>
>i tried something like this
>
>1. i retrieved the data first from empfile
>
>** rsEmpFile.Open "SELECT * FROM empfile WHERE empno = '" & txtempno.text & "'", adoEmpFile,,,adCmdText
>
>2. from the rsEmpFile.Recordset, i will use the data coming from it to retrieve the data from the other tables like this
>
>** if rsEmpFile.Recordcount = 1 then
> rsTemp.Open
, adoEmpFile,,,adCmdText
>
>...how do i do this? i really need help with it! thanks!
>
>Elinore
You can une a JOIN in your SQL query.