sql joins

-
ASQL Join is an instruction to combine data from two sets of data (tables).

SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key; it specifies that the database management system is organized in such a way that there are clear relations defined between different sets of data. (sql jons description courtesy of  sql-joins)

Different Types of SQL JOINs:



  • (INNER) JOIN: Returns records that have matching values in both tables
  • LEFT (OUTER) JOIN: Return all records from the left table, and the matched records from the right table
  • RIGHT (OUTER) JOIN: Return all records from the right table, and the matched records from the left table
  • FULL (OUTER) JOIN: Return all records when there is a match in either left or right table

image courtesy of  imgur

Comments

Post a Comment

Popular posts from this blog

Spain's nuclear legacy

-
Image
Spain's nuclear legacy By Gerry Hadden PRI's The World Continue reading the main story On a sunny morning in 1966 two US Air Force planes collided and dropped four nuclear bombs near the village of Palomares in southern Spain. There was no nuclear blast, but plutonium was scattered over a wide area - and Spain is now asking the US to finish the clean-up. The US government calls nukes that go astray "Broken Arrows" and on 17 January 1966, Palomares got four of them. Overhead, at 31,000ft, an American B-52G bomber collided with a KC-135 tanker plane during routine air-to-air refuelling and broke apart. Three of the bomber's H-bombs landed in or around Palomares, the fourth landed about five miles offshore in the Mediterranean. Manolo Gonzalez says he was standing outside when he heard a tremendous explosion. "I looked up and saw this huge ball of fire, falling through the...
Read more