Re: there are 2 SQL statements, what's different between those?

I don't think there's any difference in internal processing but prior
to V5R3, SQL syntax rules would not allow use of keyword table the way
you display in sample 1. IBM keeps adding more and more things to
comply with SQL standards and I'm not sure, but this may be one of
them.

That's why it's always a good idea to develop, or at least test your
applications on lowest level of the operating system you need to
support.

If you can't afford that, there is a Syntax Check SQL Statements API
(QSQCHKS) you could use to test validity of your SQL syntax across
several releases.

.

Relevant Pages

  • Re: Question on displaying repeating data
    ... Ok, I have the subform. ... display more than 1 row. ... The query logic is relatively simple. ... a little help in getting my SQL Syntax is also appreciated. ...
    (microsoft.public.access.forms)
  • Question on displaying repeating data
    ... I am developing a financial application that tracks various aspects of the stock and financial markets. ... I obvisously don't know the SQL syntax here, but I think the meaning is clear. ... How can I set up what I imagine is basically an array or table to display the data? ...
    (microsoft.public.access.forms)
  • BETWEEN search on text fields question
    ... I'm having a very hard time finding any information on the BETWEEN keyword when using SQL syntax in Access. ... John ...
    (microsoft.public.access.modulesdaovba)
  • Re: newbie question: results by page
    ... "Tony Marston" wrote in message ... your SQL syntax. ... Check the manual that corresponds to your MySQL server ... What I used is "ORDER BY id DESC" since I'm trying to display my records ...
    (comp.lang.php)