Hi all
In this query the syntax is correct but I dont no why its not running...
Can you check it out please?
Query:
SELECT CASE
WHEN party_x_source.partytypeid IN
(SELECT party_x_source.datasourceid
FROM party_x_source)
THEN 1
ELSE 0
END
FROM party_x_source;
Thank you
Regards,
Narendra
In this query the syntax is correct but I dont no why its not running...
Can you check it out please?
Query:
SELECT CASE
WHEN party_x_source.partytypeid IN
(SELECT party_x_source.datasourceid
FROM party_x_source)
THEN 1
ELSE 0
END
FROM party_x_source;
Thank you
Regards,
Narendra