Hi All, Need help to write an SQL, requirement is as below.
db2 =select * from dealer
D_KEY NAME
----------- ----------
1 Toyota
2 Ford
3 Chrysler
4 GM
3 record(s) selected.
db2 =select * from txn
T_KEY TNAME
----------- ----------
1 Australia
5 denmark
3 Korea
2 Kenya
2 Austria
2 America
3 England
4 Finland
8 record(s) selected.
Required O/P
T_Key Name TNAME
---- ---------- -------------
1 Toyota Australia
2 Ford Kenya
3 Chrysler Korea
Thanks, Sam