Need to get more examples on sub-query

Hi,

When i tried the following query. It didnt work properly.
SELECT * FROM orders where type in (SELECT TYPE FROM orders).
I got the error. I could see only one example in the DP4. Could you please provide some example with sub-queries.

SELECT * FROM orders where type in (SELECT RAW TYPE FROM orders).