asked on

t-sql Joining Issue

Hi , I have write code for Joining 2 tables.But it's not working properly. Any idea where I have to change.
It's duplicating same line 2 times.

Please attached excel sheet, it's showing 2 table and expected out put .

This is SQL SERVER 200R2

SELECT  A.Invoice Number,B.[Order Number],B.[F_Cost],B.[VendorNumber]




FROM TABLEB B

LEFT OUTER JOIN TABLEA  A ON B.Order_Number=A.Order_Number AND B.[Order Number Line]= A.[Order Number Line]

Open in new window

Query.xlsx

ASKER CERTIFIED SOLUTION

Pawan Kumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Peter Chan

Hi,
Try to put

seleect distinct ...

Open in new window

SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ukerandi

ASKER

@Ryan Chong

Can you give me a example how to do data mining related to above example.
Thanks

Ryan Chong

what i mean by a better data mining approach is actually referring to the possibility to add "Invoice Number" into your TableB, if that's feasible. By doing that we can ensure both comparison of TableA and TableB will not produce duplicate entries and that ensure your data accuracy.

Peter Chan

Hi Author,
Is there no more other question to this thread? If yes, we would close this!

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vitor Montalvão

ukerandi, a feedback will be appreciated.
Cheers

ukerandi

ASKER

Thanks