Hi, I have two tables: CREATE TABLE A ( ID integer primary key, SERVER_ID integer )
CREATE TABLE B ( ID integer primary key, GROUP_ID integer, SERVER_ID integer ) The following SQL does not work, complaint is "Error: no such column: B.GROUP_ID" select ID, (select SERVER_ID from A where A.ID=B.GROUP_ID) as GROUP_ID from B I realize that I can do it in other ways to make it work. However, anyone has an explanation why this SQL does not work with SQLITE? It works with MYSQL and MS ACCESS. Thanks in advance. Wei