Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
how to merge two tables into one table?
IN BOTH TABLE LVL_ID IS COMMON..
Note: Without using joins
suppose i hve fields lik
Tab1:
lOAD lvl_id,
req_id,
req_name,
req_desc,
req_priority,
create_date,
req_moddate,
create_by,
mod_by,
reqlast_action,
req_status
FROM
[$(vSourceData)\newtable5.qvd]
(qvd);
Table2:
LOAD
lvl_id,
test_id,
test_createon,
test_desc,
test_estmdevtime,
test_lastaction,
test_moddate,
test_name,
test_owner,
test_type,
tc_modifycount,
test_delflag
[$(vSourceData)\newtable6.qvd]
how can i achive dis/?
Yes, but make sure both the field should be avail in both the tables and then Composite key of those 2 or 3 or 4 fields will de the rest
thnx anand...for ur expln.
thnx all...good info
it will simply append 2nd table records/data with ur first table records/data.
means,if we can assume 1'st table is having 10 records and new flag as table1.
2nd table is having 5 records and new flag as table 2.
ur output is:
10 records with flag as table from first table
5 records from 2'nd table with ur flag as table2.
in the above case by mistaken he put flag as Table1 in both the case.
yes...but i hve 5 tables so i need those 5tables into one single table...
yes,u can do..if you want/if it meets ur requirements.
yeah...thnx shiva... i got the exact req wit anad reply.....
