Showing posts with label Outer Join. Show all posts
Showing posts with label Outer Join. Show all posts

June 16, 2014

Database Joins example!

CREATE TABLE employee
(employeeid int(10) default NULL,
employeefname varchar(12) default NULL,
employeelname varchar(12) default NULL,
CONSTRAINT employeeid PRIMARY KEY (employeeid));

May 25, 2014

Inner and Outer Joins!..




JOINS are basically used to combine the data from two tables. The temporary table is created based on column(s) that the two tables share, which represent meaningful column(s) of comparison.