41–46 of 46 posts
Thing is I want to cover the latest stable version of tools im using so i can take advantage of their latest features that might be absent on older ones and not covered by older third party content. The latest stable docs and changelogs are my best source for that.
I learned by doing queries in Microsoft Access 2000, then looking at the query in "SQL View". The nice thing about Access is that it managed table relations for you, so master/detail tables are almost trivial.
Relations are another name for the tables, relations are not the joins between them.
I learned by doing queries in Microsoft Access 2000, then looking at the query in "SQL View". The nice thing about Access is that it managed table relations for you, so master/detail tables are almost trivial.
Bit of a nitpick. Relations are another name for the tables, relations are not the joins between them.
The information about this is stored in the "Relationships Window"
Need to find that book again, but I think sql is something you need to drill.
I’ll take a look at some of the links in this thread, and I’m hoping one of them is just a giant bank of sql drills, and would be great if anyone knows of similar books/sites.
Earlier quoted context omitted.
Bit of a nitpick. Relations are another name for the tables, relations are not the joins between them.
If you have a master table with detail records, access just handles it, you don't have to do any SQL yourself to be able to just have a form that accesses them and lets you do all the CRUD operations. The information about this is stored in the "Relationships Window"
relation = table. join = relationship.
I made https://interactivesql.com to help all those people who just start to learn databases, SQL, queries, and more.
I am compiling 120+ lessons now to cover everything from the basics (select, join, group by, to CTEs, Analytic Functions, performance, reporting, and more)
Hope this helps. Feel free to let me know what do you think about it.