Busqueda Multiple en .asp

[ncianc]

Me sale este cartel en la pantalla, no como error, solo esto:


select * from Plans WHERE Pool LIKE '%PSO%' WHERE Status LIKE '%ON GOING%' WHERE Status LIKE '%ON GOING%' and Pool LIKE '%PSO%'

No me trae la table con la informacion.

Lo deje asi:

<%
poo = Request.Form ("texto")
sta = Request.Form ("nombre")
'opcional
set rs = Server.CreateObject("ADODB.Recordset")

sql = " select * from Plans "

If(poo <>"") then
sql2 = sql2 & " WHERE Pool LIKE '%" & poo & "%' "
end if

If(sta <>"") then
sql2 = sql2 & " WHERE Status LIKE '%" & sta & "%' "
end if

If(poo <>"" and sta <>"") then
sql2 = sql2 & " WHERE Status LIKE '%" & sta & "%' and Pool LIKE '%" & poo & "%' "
end if

'concateno variables
sql = sql & sql2

dbfile=Server.MapPath("fpdb/ticketsgenerales.mdb")
Set OBJdbConnection=Server.CreateObject("ADODB.Connect ion")
OBJdbConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbfile
response.write sql
response.end
rs.Open Sql, OBJdbConnection, 1, 1%>