Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- object_id | datetime | objectname | project_id
- 55 | 2014-03-24 09:55:40 | somevalue 1 | 10
- 77 | 2014-02-24 09:55:40 | somevalue | 88
- 55 | 2014-10-24 09:55:40 | somevalue2 | null
- 55 | 2014-11-24 09:55:40 | somevalue3 | 10
- 22 | 2014-12-24 09:55:40 | somevaluex | 10
- object_id | datetime | objectname | project_id
- 55 | 2014-03-24 09:55:40 | somevalue 1 | 10
- 55 | 2014-10-24 09:55:40 | somevalue2 | null
- 55 | 2014-11-24 09:55:40 | somevalue3 | 10
- 22 | 2014-12-24 09:55:40 | somevaluex | 10
- SELECT * FROM change
- LEFT JOIN (SELECT * from change AS x WHERE x.project IS NULL) AS change2
- ON change2.object_id = change.object_id
- AND change.project = 10
- SELECT * FROM change
- LEFT JOIN change AS change2
- ON change2.object_id = change.object_id
- AND change2.project is NULL
- WHERE change.project = 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement