Marco this is a syntax error most likely. You should either specify a JOIN, either INNER JOIN,LEFT JOIN etc as follows
Select * >From Tsqljobs AS T INNER JOIN Thosts AS Th ON T.host_id=Th.host_id or you can leave out AS and do : Select * >From Tsqljobs LEFT JOIN Thosts ON Tsqljobs.host_id=Thosts.host_id or you can do : Select * >From Tsqljobs,Thosts WHERE Tsqljobs.host_id=Thosts.host_id I prefer using joins and i suggest you go to the www.sqlite.org and read more about joins in sqlite. Its nicer that way. On Thu, 2006-03-23 at 10:09 +0100, Marco Fretz wrote: > hello > > i'm new in sqllite. in mysql you can select from more then 1 table by > listing them in the form statement. but that does not work in sqlite. > > > sqlite> select * from Tsqljobs Thosts WHERE Tsqljobs.host_id = > Thosts.id; > SQL error: no such column: Tsqljobs.host_id > > is there any documentation about this topic? > > thanks and kind regards > > marco >
