I have a query which is successfully running in HIVE database. This query have around 6 subqueries. I need to rewrite same query in SFMC SQL, so for the sake of testing purpose I just worked on two subqueries but it seems SFMC SQL does not support this? Or I am making any mistake here...Or is there is any work around in SFMC..
SELECT uuid, email_address, account_id as group_id, from ( SELECT distinct a.uuid, a.email_address, b.account_id as group_id, a.account_id from usca_restaurant_contact_v2 as a join usca_restaurant_contact_v2 as b on a.email_address = b.email_address ) exp_1 ( SELECT distinct a.uuid, a.group_id, a.account_id from exp_1 as a ) exp_2