Thread: SQL Server outer join

How is outerjoin represented(symbol) in sqlserver?is it different from sql?what is dynamic sql query,can you plz give me one statement?

How is outerjoin represented(symbol) in sqlserver?is it different from sql?

Outer joins are generally used to retrieve data from one table thoug there is no matchind row in left or right table.

You can access this link for Further information

msdn2.microsoft.com/en-us/library/aa213228(SQL.80) dot aspx

what is dynamic sql query,can you plz give me one statement

Dynamic SQLs are build run time by using the parameters supplied by user.
The statements build using parameters can be executed using sp_executesql
The major problem with dynamic SQL is SQLInjection , due to which database becomes vulnerable
You can learn about Dynamic SQL more sommarskog.se/dynamic_sql dot html

HTH

i want following result how is use query

project ename
CRM raja
ramu
tata
ERP arun
priya
vel

here project column is not return again and again project name
coming in front page using dot net.

is it possible in sqlserver query.

thanks

When we want to sellect data from two tables at a time, then we will go for Joins Operation.

To select Matched records as well as Unmatched records from two tables go for Outer Join Operation. It is of two types

1. Left Outer Join

Select table1.column1, table1.column2...........,table2.column1,table2.column2.............. from table1, table2 where table1.commancolumn *= table2.commancolumn

2. Right Outer Join:

Select table1.column1, table1.column2...........,table2.column1,table2.column2.............. from table1, table2 where table1.commancolumn =* table2.commancolumn


Cheers
Prashanth Chenna,