|
|
|
|
|
by tkejser
122 days ago
|
|
I didn't really write USING in anger until around 10 years ago, and I have been around a long time too. Not all databases support it. But once you start using it (pun) - a lot of naming conventions snap into place. It has some funky semantics you should be aware of. Consider this: CREATE TABLE foo (x INT);
CREATE TABLE bar (x INT);
SELECT \* FROM foo JOIN bar USING (x);
There is only one `x` in the above `SELECT *` - the automatically disambiguated one. Which is typically want you want. |
|