sql server - Incorrect syntax near the keyword 'with' (SQL) -
I have a bit of a weird problem.
When I run it on SQL:
with as IDHTable (more than SS_ID) by line number (SS_ID from order), line_ID from slide_ash In the form, select slide_show from SDIID) * Using TDO * T1 as TDI internally slide_show T. on T1. Ties_ID = Join T0.SS_ID T1.row_id between 0 and 1 Order t1.row_id asc; Runs in SQL Express
and returns the first line, as it should (similar to the range 0,1 in MySQL). However, when I run it in Delphi via the TADOQuery object, I get an error in the headline. I'm guessing ADO Objects like to do something, but I do not understand.
Note: This is the correct SQL which I am passing in the ADO object.
Anyone have any ideas?
Try:
SELECT t0. * From (SE_O_ID) (SD_IND by SR_ID) (SR_ID by ARDIIP, Slide_Show from SS_ID) AS T1 Join Join T1 on T1 as Slide_Show SSIID = T.SS_ID WHERE T.OriIIID 0 and 1 ORD BY T.OoIID ASC;
Comments
Post a Comment