Dear all,
I am trying to execute this query : SELECT distinct(buyerid) from transaction
WHERE buyerid NOT IN(SELECT distinct(sellerid) from transaction)
This gives me the following error:
FAILED: Parse Error: line 1:59 cannot recognize input near 'SELECT' 'distinct'
'(' in expression specification
How can I rectify the query to get it working?
Thanks and Regards,
Prakrati
________________________________
This email message may contain proprietary, private and confidential
information. The information transmitted is intended only for the person(s) or
entities to which it is addressed. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited and may be
illegal. If you received this in error, please contact the sender and delete
the message from your system.
Mu Sigma takes all reasonable steps to ensure that its electronic
communications are free from viruses. However, given Internet accessibility,
the Company cannot accept liability for any virus introduced by this e-mail or
any attachment and you are advised to use up-to-date virus checking software.
