- Inner Join
- Left Join
- Right Join
- Full Join
INNER JOIN = JOIN
LEFT JOIN = LEFT OUTER JOIN
RIGHT JOIN = RIGHT OUTER JOIN
FULL OUTER JOIN
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
September 02, 2013
SQL Aliases - Combine the column
SQL Syntax:
Select
CustomerName,
Address + ',' City + ',' + Postcode + ',' Country AS Address
From
Customers;
Results:
Select
CustomerName,
Address + ',' City + ',' + Postcode + ',' Country AS Address
From
Customers;
Results:
