Use JOIN vs. UNION in SQL

Use JOIN vs. UNION in SQL

So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.

Hosted by youtube.com
Creator's Site: www.learnitfirst.com
Curated By: Rube McGee

Comments

Add your comment:

Tattoo Yourself (or Your Girlfriend)

Henna. Beautiful, fun, exotic... and best of all... Do-It-Yourself (with a little practice). Also, unlike tattoos, it's temporary. Henna generally lasts for 1-3 weeks. An ancient tradition, henna is ...

The Mother of all Ping Pong Guns - LETHAL

The lethal pneumatic ping pong gun. This thing isn't exactly wife approved. Creator Ron Kessinger built this mighty powerful ping pong launcher - "a variation on a potato cannon, built to run on ...

Old Bumper Cars Go Street Legal

Flickr user MR38 has posted a set of photos of bumper cars made street legal, as displayed at the annual Cruisin’ Grand festival in Escondido, California. This mini cars were retrofitted with 750 cc ...

Human Powered Ferris Wheel

According to Google's (albeit rough) translation from French to English: "A big wheel in India that does not work with an engine but using human power. Men throw themselves in front of the wheel ...

Make-It-Yourself LEGO Gummies

Turkey day is over, and you have this nice Friday-Saturday-Sunday stretch before it's back the daily grind. Here's a project that inspires both young and old: LeGummies brick shaped gummy candies ...

loading...