.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

  Sort: Rank

SQL Joins
What is the difference between Inner Join and Outer Join? 1. You use INNER JOIN to return all rows from both tables where there is a match. ie. in the resulting table all the rows and colums will have values. In OUTER JOIN the relulting table may have empty colums. Outer join may be either LEFT or R... 2008-09-25, 6420👍, 0💬

  Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML