{"action":"created","issue":{"url":"https://api.github.com/repos/requery/requery/issues/35","repository_url":"https://api.github.com/repos/requery/requery","labels_url":"https://api.github.com/repos/requery/requery/issues/35/labels{/name}","comments_url":"https://api.github.com/repos/requery/requery/issues/35/comments","events_url":"https://api.github.com/repos/requery/requery/issues/35/events","html_url":"https://github.com/requery/requery/issues/35","id":140461585,"number":35,"title":"Table joins","user":{"login":"echistyakov","id":7972340,"avatar_url":"https://avatars.githubusercontent.com/u/7972340?v=3","gravatar_id":"","url":"https://api.github.com/users/echistyakov","html_url":"https://github.com/echistyakov","followers_url":"https://api.github.com/users/echistyakov/followers","following_url":"https://api.github.com/users/echistyakov/following{/other_user}","gists_url":"https://api.github.com/users/echistyakov/gists{/gist_id}","starred_url":"https://api.github.com/users/echistyakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/echistyakov/subscriptions","organizations_url":"https://api.github.com/users/echistyakov/orgs","repos_url":"https://api.github.com/users/echistyakov/repos","events_url":"https://api.github.com/users/echistyakov/events{/privacy}","received_events_url":"https://api.github.com/users/echistyakov/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/requery/requery/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-03-13T07:39:32Z","updated_at":"2016-03-13T18:15:13Z","closed_at":null,"body":"How do joins work in requery? Let's say my schema has 3 entities: Sailor(id), Boat(id, color), Reservation(sid, bid, date). Is there a way to get all Sailors who reserved a red Boat?\r\nI see that requery has a Join interface, but I couldn't find a way to join tables on foreign keys."},"comment":{"url":"https://api.github.com/repos/requery/requery/issues/comments/196015207","html_url":"https://github.com/requery/requery/issues/35#issuecomment-196015207","issue_url":"https://api.github.com/repos/requery/requery/issues/35","id":196015207,"user":{"login":"echistyakov","id":7972340,"avatar_url":"https://avatars.githubusercontent.com/u/7972340?v=3","gravatar_id":"","url":"https://api.github.com/users/echistyakov","html_url":"https://github.com/echistyakov","followers_url":"https://api.github.com/users/echistyakov/followers","following_url":"https://api.github.com/users/echistyakov/following{/other_user}","gists_url":"https://api.github.com/users/echistyakov/gists{/gist_id}","starred_url":"https://api.github.com/users/echistyakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/echistyakov/subscriptions","organizations_url":"https://api.github.com/users/echistyakov/orgs","repos_url":"https://api.github.com/users/echistyakov/repos","events_url":"https://api.github.com/users/echistyakov/events{/privacy}","received_events_url":"https://api.github.com/users/echistyakov/received_events","type":"User","site_admin":false},"created_at":"2016-03-13T18:15:13Z","updated_at":"2016-03-13T18:15:13Z","body":"Thank you for the quick response! The above query, however, results in a compilation error because `eq()` expects an Integer but gets a QueryAttribute instead. Am I missing something?"}}