Popular posts from this blog
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