Incorrect Syntax near ""

Question

Hi Incorrect Syntax near '' CASE WHEN T1.'TransType' = '13' THEN (Select max(A0.CardCode') from ONV A0 where A0.'TransId' = T1.'TransId') WHEN T1.'TransType' = '14' THEN (Select max(A0.'LocCode') from ORIN A0 where A0.'TransId' = T1.'TransId') End As 'Vendor' Thanks

Sangeetha S · Answer

Let's correct it: CASE WHEN T1."TransType" = '13' THEN (SELECT MAX(A0."CardCode") FROM ONV A0 WHERE A0."TransId" = T1."TransId") WHEN T1."TransType" = '14' THEN (SELECT MAX(A0."LocCode") FROM ORIN A0 WHERE A0."TransId" = T1."TransId") END AS "Vendor"

Sophia Carter · Answer

Hi there! It looks like the issue in your SQL query is around the incorrect syntax near the quotation mark in your subqueries. Specifically, in the lines: (Select max(A0.CardCode") from ONV A0 where A0."TransId" = T1."TransId") (Select max(A0."LocCode") from ORIN A0 where A0."TransId" = T1."TransId") The problem lies with the ending quotation mark in `A0.CardCode"` and the missing backtick in the `Select max(A0."LocCode")` part of your subqueries. To correct the syntax, you should adjust these lines to: (SELECT max(A0."CardCode") from ONV A0 where A0."TransId" = T1."TransId") (SELECT max(A0."LocCode") from ORIN A0 where A0."TransId" = T1."TransId") By making these adjustments, you'll have properly formatted subqueries, and your SQL should execute without syntax errors. If you have any more questions or need further clarification, feel free to ask!

Incorrect Syntax near ""

Answers (2)