What are joins..how many types of joins are there?
Answer Posted / akn
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
| Is This Answer Correct ? | 73 Yes | 40 No |
Post New Answer View All Answers
What is the difference between "as" and "is" in an oracle stored procedure?
What is bulk load in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
Point out the difference between user tables and data dictionary?
How does one get the view definition of fixed views/tables?
Is it possible to split the print reviewer into more than one region ?
What is parameterized cursor in oracle?
What is a lookup table in oracle?
What is the quickest way to export a table to a flat file?
How many types of segments in Oracle?
Explain the different normalization forms?
Why does for update in oracle 8 cause an ora-01002 error?
How do I manually uninstall oracle client?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What types of joins are used in writing subqueries?