Re: [sqlite] Problems with some SQL statements

[Robert L Cochran]

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,
       Y.TeamName,
       X.Points
FROM   (       SELECT A.TeamID,
                      B.TeamName,
                      A.Points

FROM (

Use an AS clause like this:

 FROM   (       SELECT A.TeamID AS TeamID,
                        B.TeamName AS TeamName,
                        A.Points AS Points
                 FROM    (


I made a similar changes in all of your queries and
they seem to work fine now.
--
D. Richard Hipp   <[EMAIL PROTECTED]>