SQL Statement - NOT EXISTS

[szadroga]

I am using the following SQL but for some reason NOT EXISTS is being underlined as being incorrect.  The query still works and I am able to build my report in JS Studio 6 but can't figure out what the arguement is

 

SELECT *
FROM dsat_export
WHERE serial_item = 'Y' AND NOT EXISTS (SELECT 1
              FROM oracle_export
              WHERE oracle_export.serial_number=dsat_export.serial_number);

[hozawa]

Create a case in Tracker. I've also found some syntax that displays error messages but executes OK by just ignoring them. Studio team is very quick in getting these fixes quickly.

[szadroga]

how do i go about creating a case in Tracker?

[szadroga]

I have created a case in Tracker for this issue