{"action":"created","issue":{"url":"https://api.github.com/repos/datacarpentry/sql-ecology/issues/68","labels_url":"https://api.github.com/repos/datacarpentry/sql-ecology/issues/68/labels{/name}","comments_url":"https://api.github.com/repos/datacarpentry/sql-ecology/issues/68/comments","events_url":"https://api.github.com/repos/datacarpentry/sql-ecology/issues/68/events","html_url":"https://github.com/datacarpentry/sql-ecology/pull/68","id":129710597,"number":68,"title":"Introduced 'USING'","user":{"login":"c-martinez","id":7782231,"avatar_url":"https://avatars.githubusercontent.com/u/7782231?v=3","gravatar_id":"","url":"https://api.github.com/users/c-martinez","html_url":"https://github.com/c-martinez","followers_url":"https://api.github.com/users/c-martinez/followers","following_url":"https://api.github.com/users/c-martinez/following{/other_user}","gists_url":"https://api.github.com/users/c-martinez/gists{/gist_id}","starred_url":"https://api.github.com/users/c-martinez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/c-martinez/subscriptions","organizations_url":"https://api.github.com/users/c-martinez/orgs","repos_url":"https://api.github.com/users/c-martinez/repos","events_url":"https://api.github.com/users/c-martinez/events{/privacy}","received_events_url":"https://api.github.com/users/c-martinez/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-29T09:17:44Z","updated_at":"2016-01-29T11:13:07Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/datacarpentry/sql-ecology/pulls/68","html_url":"https://github.com/datacarpentry/sql-ecology/pull/68","diff_url":"https://github.com/datacarpentry/sql-ecology/pull/68.diff","patch_url":"https://github.com/datacarpentry/sql-ecology/pull/68.patch"},"body":"As discussed in PR #67 , the key word `USING` is introduced in the lesson.\r\n\r\nI've decided to introduce `USING` first, and then `ON` as an alternative when column names do not match. This seems more logical to me, but it could also be the other way around. What do you think @ethanwhite @waveform80 ?"},"comment":{"url":"https://api.github.com/repos/datacarpentry/sql-ecology/issues/comments/176698040","html_url":"https://github.com/datacarpentry/sql-ecology/pull/68#issuecomment-176698040","issue_url":"https://api.github.com/repos/datacarpentry/sql-ecology/issues/68","id":176698040,"user":{"login":"waveform80","id":1076190,"avatar_url":"https://avatars.githubusercontent.com/u/1076190?v=3","gravatar_id":"","url":"https://api.github.com/users/waveform80","html_url":"https://github.com/waveform80","followers_url":"https://api.github.com/users/waveform80/followers","following_url":"https://api.github.com/users/waveform80/following{/other_user}","gists_url":"https://api.github.com/users/waveform80/gists{/gist_id}","starred_url":"https://api.github.com/users/waveform80/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/waveform80/subscriptions","organizations_url":"https://api.github.com/users/waveform80/orgs","repos_url":"https://api.github.com/users/waveform80/repos","events_url":"https://api.github.com/users/waveform80/events{/privacy}","received_events_url":"https://api.github.com/users/waveform80/received_events","type":"User","site_admin":false},"created_at":"2016-01-29T11:13:07Z","updated_at":"2016-01-29T11:13:07Z","body":"It's a nice idea, but given that USING isn't universally implemented (while ON is, although they're both \"standard\" SQL), I'm a bit nervous about introducing it first (at the very least, we'd need to stress that users may find USING unsupported).\r\n\r\nI'd say that ON is considered the \"canonical\" method of specifying JOIN criteria and USING is regarded as a convenient short-hand. But from my experience, it's quite rarely used in practice (even in those engines that support it), although I'm not sure why. Possibly because having common column names isn't actually *that* common in real-world schemas, or perhaps it's just users' ignorance of the facility?"}}