Eliminate Duplicate

[tarriqSQL]

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

[Claire]

Since you didnt specify any condition for QA to execute and filter the result you want,it's retional to have such result.

The following is one of the queries can lead the result you want


select b.*,a.Claim,a.shiptype from tablea a,tableb b where Claim = 100 and Cost = 50 or Claim = 200 and cost = 100