Every time I write a SQL statement that has a JOIN like this...
1: SELECT *
2: FROM Products
3: INNER JOIN Categories ON Categories.category_id = Products.category_id
I wonder why I can't just write it like this...
1: SELECT *
2: FROM Products
3: INNER JOIN Categories ON category_id
That's not so needy, is it?
Yes, I know tools like Red-Gate SQL Query Intellisense Tool ease this pain, but I've had problems with such tools and I've uninstalled them. Plus, the code is still there, cluttering up my screen. And code is bad anyway.