Table A

JobNo Claim ShipType
A1 100 I
A1 200 II

Table B

JobNo Cost
A1 50
A1 100

Result Expected


JobNO Cost Claim Shiptype
A1 50 100 I
A1 100 200 II

Hi all,
i've given a table structure with data
and the expected result .
I want to establish it in SQL server (7.0)
If i establish the inner join i get 4 rows (2*2)
Please let me know how to get the result
Thanx in adv
Tarriq