-
Eliminate Duplicate
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|