Hi

I am not getting u your doubt is joint or join

we can join two tables by primary and forienkeys of both tables in sql statements you can also specify the field to be displayed in ur join from two tables

suppose we have two tables

emp dept

emp: emp-no emp- name emp- sal dept-no

dept: dept-no dept-loc dept-strength

no we can join these tables by using sql statement

select emp-no emp-name emp-sal dept-no dept loc dept- strength from emp dept where emp.dept-no dept.dept-no

The SQL JOIN statement is used to combine the data contained in two relational database tables based upon a common attribute.

Basically there are two types of Joins

1. Inner Join

An inner join is a join that selects only those records from both database tables that have matching values. Records with values in the joined field that do not appear in both of the database tables will be excluded from the query. One or more fields can serve as the join fields.

2. Outer Join

Outer Join has 2 types furthure.

2a. Right Outer Join : 2b. Left Outer Join

An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field. In a left outer join the selected records will include all of the records in the first database table. In a right outer join the selected records will include all records of the second database table. One or more fields can serve as the join fields.

Joins are the function by which you can combine two or more tables to get the desired records types of joins are:

Self-join natural join right outer join left outer join equijoin non-equijoin etc.

Sandeep

joint means nothing bot to join the two tables

these r 3 types

inner self and outer joins.

suppose if we want emp1 details from 1 table and emp2 details from other table in this we can use join......k

if u have any doubts send to :chinnu.sep14@gmail.com

Actually it is not a joint? It is join?

Joins are used to retrieve data from multiple tables.There are 3 types of joins
a)Inner Join b)Outer Join c) Cross Join
a)Inner Join is the default type of join Result set contains only matched rows.
b)Outer Join: We have 3 types of outer join .They are
1)Left Outer Join: Result set contains all rows from the left table and matched rows from the right table
2)Right Outer Join:Result set contains all rows from the right table and matched rows from the left table
3)Full Outer Join: Result set contains all rows from left table as well as rows from the right table.
c)Cross Join: A join without any condition every row in first table joined with every row in 2nd table.This join is also called as cartesian join