murach’s T-SQL: Joined at the Tables

*NOTICE Code Snippets cannot be seen on WordPress Reader, must be viewed on original site ammccann.com

sql

Joining is a concept once foreign, now known, don’t forget! I once saw an Ad for a job posting that said specifically, “Can do ten table joins without fear,” as a requirement. Ha! I get it, but I started with two, not so bad once you figure out what the hell a relationship is. Code:

Unions seemed pretty important, too, but they can apparently have performance issues. Hey, though, they work! Work first, optimization second, right? Maybe, like I said, just getting started! A few more organized exercises. Code:

The last thing I worked on was the Guitar Shop selection. Code:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s