Re: [sqlite] how to join 3 tables from a sqlite database?

2014-03-25 Thread Keith Medcalf
>On 25 March 2014 14:09, Christian Dallinger > wrote: >> Hello, I want to join these 3 tables from my database: >> >> http://pastebin.com/f8FP0G0C > >something like > >select Macadress, timestamp, result, user, '', '', '', '' from checklog >union >select MacAdress, timestamp, '', '', '', error1,

Re: [sqlite] how to join 3 tables from a sqlite database?

2014-03-25 Thread Simon Davies
On 25 March 2014 14:09, Christian Dallinger wrote: > Hello, I want to join these 3 tables from my database: > > http://pastebin.com/f8FP0G0C something like select Macadress, timestamp, result, user, '', '', '', '' from checklog union select MacAdress, timestamp, '', '', '', error1, error2, error

[sqlite] how to join 3 tables from a sqlite database?

2014-03-25 Thread Christian Dallinger
Hello, I want to join these 3 tables from my database: http://pastebin.com/f8FP0G0C ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to join 3 tables?

2009-10-07 Thread Kermit Mei
On Tue, 2009-10-06 at 21:14 -0700, Darren Duncan wrote: > Kermit Mei wrote: > > 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

Re: [sqlite] How to join 3 tables?

2009-10-06 Thread Kermit Mei
On Wed, 2009-10-07 at 12:10 +0800, Kermit Mei wrote: > 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 li

Re: [sqlite] How to join 3 tables?

2009-10-06 Thread Darren Duncan
Kermit Mei wrote: > 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 ".": sy

[sqlite] How to join 3 tables?

2009-10-06 Thread Kermit Mei
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.