Using result set and setting it to another select statement

[gio2888]

This might be confusing, I will do my best to describe my problem. Heres the sql statement I am running...

select * from portal P, portal_title C where P.category = C.category AND (name like '%is%' or portal_keywords like '%is%')

I want to take one field from the recordset, and input it as a search variable in another select statement.

select * from portal_main where name= <--- place the one of the result fields there....

Is there a way I can consolidate the 2 sql statements together?

Thanks for the help!

 

[swampBoogie]

select * from portal_main where name in (
select <apropriate-column> 
  from portal P, portal_title C 
where P.category = C.category 
AND (name like '%is%' or 
portal_keywords like '%is%'))

 

[gio2888]

thanks!