Interested to Buy Any Domain ? << Click Here >> for more details...
What technique is used to retrieve data from more than one
table in a single SQL statement?
- 9 Answers
- 15376 Views
- CTS, IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mani
Both UNION or UNION ALL and JOIN can be used.
The purpose of retreiving data from more than one table in a
single statement generally happens when the ouput of the
involved tables has same table structure and in this case
either UNION (to eliminate the duplicates in the resultant
table)or UNION ALL (to retain the duplicates in the
resultant table)could be used.
If retrieval is based on seletion criterion then JOINS could
also be used but here the resultant table structure can be
different from that of the tables involved in join operation.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ravi
We can do this by using JOINS as well as Sub Queries
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / rahul
select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st>,<Table name2nd>;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anjireddy vintha
By using JOINS and UNIONS we can retive data from
morethan one table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / karthik
select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st> join <Table name2nd> where
table1.columnname = table2.columnname;
atleast one column should be unique in both the tables.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ajay rana
join techniques is used to to retrieve data from more than
one table in a single SQL statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / biryuk
UNION could be used to retrieve data from more than one
table as well.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / bala
Using Temp Table data can be retrieved from more than one
table.
| Is This Answer Correct ? | 0 Yes | 3 No |
What are the full forms of spufi and dclgen and why are they used?
What is copy pending and check pending in db2?
Can we able to find all the Table names under a Particular Plan?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is buffer pool in the db2 database?
How to check sequence on a table in db2?
How to check table size in db2 sap?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
What is null indicator in cobol db2?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How to find the number of rows in a db2 table?
What is the difference between SYNONYM and ALIAS?
COBOL 
