Hello, I have three tables like this: HomeDev(id,...,text) ZPhDev(id,...,HomeDevId) ZGroupItem(id,...,groupId,ZPhDevId)
Now, I want to get the items like this: ZPhDev.id, and its corresponding HomeDev.text, the relation is like this: 1. Get ZGroupItem.ZPhDevId When I know groupId 2. Get ZPhDev.HomeDevId When ZPhDev.id = ZGroupItem.ZPhDevId 3. Get HomeDev.text When ZPhDev.HomeDevId = HomeDev.id How can I do it in only one sql command? I wrote it like this, but it can't run: sqlite> SELECT ZGroupItem.ZPhDevId HomeDev.text FROM ZGroupItem ...> INNER JOIN ZPhDev ON ZGroupItem.ZPhDevId = ZPhDev.id ...> WHERE ZGroupItem.groupId = 1; SQL error: near ".": syntax error How to solve it? Thanks. Kemrit Mei _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
