Linear syntax: Difference between revisions

Revision as of 23:54, 1 February 2010

Revision as of 20:53, 6 April 2010

Line 6:

== SQL syntax ==

SELECT ATABLE.ACOL1, ATABLE.ACOL2, ATABLE.ACOL3, BTABLE.BCOL3, CTABLE.CCOL5 FROM ATABLE, BTABLE, CTABLE WHERE ATABLE.ACOL1=BTABLE.ACOL1 AND BTABLE.BCOL5=CTABLE.CCOL1 ORDER BY ATABLE.ACOL3 DESC

or Select * from table_name;(* for all)

== HTML syntax ==