Inner Join

[#1]

We have 2 tables namely INVOICE(with fields invoice no, contract no, invoice weight(kg)) and CONTRACT(with fields contract no , contract weight(kg)). How we can perform an inner join to merge the two tables? Plz send the codes for the above.

[#2]

user the inner join command.

LOAD

....

from tableA

INNER JOIN

LOAD

...

from tableB

The inner join will be based on the common field name. In this case, the Contract No.