Comparing data in two different DB2 tables.

[kottav]

Hi ,

I need this very urgently..can someone help me out.

I need to compare the data from two different tables. Wat are all the possible solutions.

Table 1:
Dept
Item

Tables2
item.

Please help me out.

[Peter55]

Your 2 tables appear to be completely different.
How do you plan to compare them?
A table with 1 column can never be like a table with 2 columns.
Or do you disagree?