{"action":"created","issue":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/545","labels_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/545/labels{/name}","comments_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/545/comments","events_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/545/events","html_url":"https://github.com/Raizlabs/DBFlow/issues/545","id":126957519,"number":545,"title":"Qualify column name in SELECT statment??","user":{"login":"marwfair","id":4564566,"avatar_url":"https://avatars.githubusercontent.com/u/4564566?v=3","gravatar_id":"","url":"https://api.github.com/users/marwfair","html_url":"https://github.com/marwfair","followers_url":"https://api.github.com/users/marwfair/followers","following_url":"https://api.github.com/users/marwfair/following{/other_user}","gists_url":"https://api.github.com/users/marwfair/gists{/gist_id}","starred_url":"https://api.github.com/users/marwfair/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marwfair/subscriptions","organizations_url":"https://api.github.com/users/marwfair/orgs","repos_url":"https://api.github.com/users/marwfair/repos","events_url":"https://api.github.com/users/marwfair/events{/privacy}","received_events_url":"https://api.github.com/users/marwfair/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-01-15T21:02:20Z","updated_at":"2016-01-18T17:51:29Z","closed_at":"2016-01-18T17:50:08Z","body":"I am trying to use the JOIN query, but I am getting an \"ambiguous column name: id\" error. I am guessing this is because I am selecting the \"id\" column of a table, and every one of my tables has an \"id\" column as a primary key. If I don't select the \"id\" field, my JOIN statement works fine. If I leave the .select() empty and let it return all of the columns, the \"id\" column does not have the correct ids.\r\n\r\nIs it possible to qualify my column names in the select statement with the table name?\r\n\r\nIt is currently:\r\nSQLite.select(MyTable_Table.id).from(MyTable.class)....\r\n\r\nI would need to do something like this:\r\nSQLite.select(MyTable.MyTable_Table.id).from(MyTable.class)...."},"comment":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/comments/172604939","html_url":"https://github.com/Raizlabs/DBFlow/issues/545#issuecomment-172604939","issue_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/545","id":172604939,"user":{"login":"marwfair","id":4564566,"avatar_url":"https://avatars.githubusercontent.com/u/4564566?v=3","gravatar_id":"","url":"https://api.github.com/users/marwfair","html_url":"https://github.com/marwfair","followers_url":"https://api.github.com/users/marwfair/followers","following_url":"https://api.github.com/users/marwfair/following{/other_user}","gists_url":"https://api.github.com/users/marwfair/gists{/gist_id}","starred_url":"https://api.github.com/users/marwfair/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marwfair/subscriptions","organizations_url":"https://api.github.com/users/marwfair/orgs","repos_url":"https://api.github.com/users/marwfair/repos","events_url":"https://api.github.com/users/marwfair/events{/privacy}","received_events_url":"https://api.github.com/users/marwfair/received_events","type":"User","site_admin":false},"created_at":"2016-01-18T17:51:29Z","updated_at":"2016-01-18T17:51:29Z","body":"@shanrod220 Thank you!"}}