Re: [sqlite] Problems with some SQL statements

I always keep a few books on SQL around me. Bob [EMAIL PROTECTED] wrote: Ken & Deb Allen <[EMAIL PROTECTED]> wrote: > The following statement works in other databases but fails in SQLite with "SQL error: no such column: X.TeamID" SELECT X.TeamID, X.TeamName, Y.TeamID,

Re: [sqlite] Problems with some SQL statements

Ken & Deb Allen <[EMAIL PROTECTED]> wrote: > > > The following statement works in other databases but fails in > SQLite with "SQL error: no such column: X.TeamID" > > SELECT X.TeamID, > X.TeamName, > Y.TeamID, > Y.TeamName, > X.Points > FROM ( SELECT

[sqlite] Problems with some SQL statements

I have some SQL statements that the 3.3.2 engine does not seem to handle properly. The project with which this is associated is keeping track of the game schedule for a Little League division, and being able to produce the proper standings at the end of the season. The standings are first