Join Query- Help!

Question

Post reply

Join Query- Help!

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ganeshc27 SSC Eights! Points: 972 More actions · Answer 1

Try this...

SELECT A.*

FROM CUSTOMERBRANCH A

WHERE NOT EXISTS (SELECT * FROM [SERVER].[DATABASE].DBO.TBCUSTBRANCH B WHERE A.ACCPACCODE = B.ACCPACCODE)

Regards,

Ganesh

Gavin Oosthuizen Old Hand Points: 365 More actions · Answer 2

Ganesh, thanks a stack! This is exactly what I needed!

John Rowan SSC Guru Points: 56440 More actions · Answer 3

Or use an ANSI OUTER JOIN:

SELECT A.*

FROM CUSTOMERBRANCH A

LEFT JOIN [SERVER].[DATABASE].DBO.TBCUSTBRANCH B

ON A.ACCPACCODE = B.ACCPACCODE

WHERE B.ACCPACCODE IS NULL

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Sergiy SSC Guru Points: 110209 More actions · Answer 4

Only one point:

remote query will copy the whole remote table to local server. No use of index, no way for optimiser to do its job.

So, on big tables this query will be really sloooow.

_____________
Code for TallyGenerator