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]>
