Subquery Question

In some SQL flavors I can do something like

SELECT cola, colb, (Select cola from tablea where tablea.colb = tablec.cola) from tablec;

basically I can use a select that returns one value as a column.

I can not do this in Oracle 8. What is the workaround?

Thanks.

• Paul