{"action":"created","issue":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/396","labels_url":"https://api.github.com/repos/begriffs/postgrest/issues/396/labels{/name}","comments_url":"https://api.github.com/repos/begriffs/postgrest/issues/396/comments","events_url":"https://api.github.com/repos/begriffs/postgrest/issues/396/events","html_url":"https://github.com/begriffs/postgrest/issues/396","id":119420337,"number":396,"title":"I wonder if there is (or should be) a way to JOIN (left join, right join, etc) tables?","user":{"login":"uuhan","id":3286111,"avatar_url":"https://avatars.githubusercontent.com/u/3286111?v=3","gravatar_id":"","url":"https://api.github.com/users/uuhan","html_url":"https://github.com/uuhan","followers_url":"https://api.github.com/users/uuhan/followers","following_url":"https://api.github.com/users/uuhan/following{/other_user}","gists_url":"https://api.github.com/users/uuhan/gists{/gist_id}","starred_url":"https://api.github.com/users/uuhan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uuhan/subscriptions","organizations_url":"https://api.github.com/users/uuhan/orgs","repos_url":"https://api.github.com/users/uuhan/repos","events_url":"https://api.github.com/users/uuhan/events{/privacy}","received_events_url":"https://api.github.com/users/uuhan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2015-11-30T05:21:36Z","updated_at":"2015-12-07T23:11:06Z","closed_at":null,"body":"Some thing like \r\nhttp://localhost/table1^table2?table1.id=table2.id&select=xxx\r\n\r\nselect xxx from table1 left join table2 on table1.id = table2.id"},"comment":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/comments/162701008","html_url":"https://github.com/begriffs/postgrest/issues/396#issuecomment-162701008","issue_url":"https://api.github.com/repos/begriffs/postgrest/issues/396","id":162701008,"user":{"login":"ruslantalpa","id":5537246,"avatar_url":"https://avatars.githubusercontent.com/u/5537246?v=3","gravatar_id":"","url":"https://api.github.com/users/ruslantalpa","html_url":"https://github.com/ruslantalpa","followers_url":"https://api.github.com/users/ruslantalpa/followers","following_url":"https://api.github.com/users/ruslantalpa/following{/other_user}","gists_url":"https://api.github.com/users/ruslantalpa/gists{/gist_id}","starred_url":"https://api.github.com/users/ruslantalpa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ruslantalpa/subscriptions","organizations_url":"https://api.github.com/users/ruslantalpa/orgs","repos_url":"https://api.github.com/users/ruslantalpa/repos","events_url":"https://api.github.com/users/ruslantalpa/events{/privacy}","received_events_url":"https://api.github.com/users/ruslantalpa/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T23:11:06Z","updated_at":"2015-12-07T23:11:06Z","body":"Exactly.\r\nSo if you run the old query, the \"life\" record is missing?"}}