What do this say to you?

[Nicodemas]

"SELECT * FROM tblQuestions Q, tblTests T WHERE T.TestID = Q.TestID AND T.TestName = '" & strTestName & "'"

[jpmoriarty]

i'd reckon:

select everything from the table tblQuestions (which we'll call Q) and the table tblTests (which we'll call T) where the value of tesiID in each table match and the value of Testname in the table T is equal to the string given.

but that's just guessing - i dont know if it's legal code or not