Query/Subquery help

Is there a simple way to use the results of a subquery as the condition of a query?

I have a table with several prefixed columns and would like to obtain the values of those prefixed columns only. It seems like I should be able to do something like this:

select (select cname from col where tname=<table> and cname like <prefix%>) from <table> where...

This returns multiple values and I need a way to iterate thru the subquery to avoid the "single row subquery returns more than one row" error message.

TIA Received on Tue Jul 03 2001 - 15:38:15 CEST