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.
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).