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
- 15382 Views
- CTS, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is bind and rebind in db2?
What is the syntax for creating a table in the db2 database?
Explain db2.
What does db2 stand for?
What is a db2 package?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does runstats do in db2?
How do I delete a table in database?
What is dpf in db2?
What is the reason behind not using select * in embedded sql programs?
Explain the function done by data manager?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do we specify index to include or not during bind process.
What is database alias db2?
Is it possible using max on a char column?
