Comment on Databases should contain their own Metadata – Use SQL EverywhereparentComments−tkejser6moI 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.
Comments
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:
There is only one `x` in the above `SELECT *` - the automatically disambiguated one. Which is typically want you want.