Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- I want to join 3 tables from my database:
- table checklog:
- MacAdress timestamp result user
- 4C626D3BB6D4 1394 1 frank
- 4C626D3BB6D4 1395 0 dave
- table service:
- MacAdress timestamp text
- 5C626D3BB6D5 1396 test
- table error:
- MacAdress timestamp error1 error2 errortext
- 4C626D3BB6D4 1397 0 0 OK
- Result should be:
- MacAdress timestamp result user text error1 error2 errortext
- 4C626D3BB6D4 1394 1 frank
- 4C626D3BB6D4 1395 0 dave
- 5C626D3BB6D5 1396 test
- 4C626D3BB6D4 1397 0 0 OK
- What SQLite command should i use to get the above result?
- The database structure is as follows:
- CREATE TABLE [checklog](
- [MacAdress] TEXT NOT NULL ,
- [timestamp] INTEGER NOT NULL ,
- [result] INTEGER ,
- [user] TEXT ,
- CONSTRAINT [sqlite_autoindex_checklog_1] PRIMARY KEY
- ( [MacAdress], [timestamp] ));
- CREATE TABLE [error](
- [MacAdress] TEXT NOT NULL ,
- [timestamp] INTEGER NOT NULL ,
- [error1] INTEGER ,
- [error2] INTEGER ,
- [errortext] TEXT ,
- CONSTRAINT [sqlite_autoindex_error_1] PRIMARY KEY
- ( [MacAdress], [timestamp] ));
- CREATE TABLE [service](
- [MacAdress] TEXT NOT NULL ,
- [timestamp] INTEGER NOT NULL ,
- [text] TEXT ,
- CONSTRAINT [sqlite_autoindex_service_1] PRIMARY KEY
- ( [MacAdress], [timestamp] ));
Advertisement
Add Comment
Please, Sign In to add comment