I wrote one common query which will be run on Access,SQl and oracle.now i want to write the subquery in where clause which contains some id which i want to add in where clause.This id has been stored in .txt file.
i made one recordset from that text file.i want to use that recordset in subuquqry. i have written that query using VB.6.0 and ADO object.
is it possible to use recordset in where clause of select query.
or is there any other way to include text file's data in subquery of select query.
thanks in advance