[Resolvido] select dentro de outro select

isto é possivel?

Set rs = conn.Execute("select * from patient where center like("select center from users where username like '" & user& "'") order by data_reg " & dir&"")

obrigado