Fetch only matching data between 2 tables - union or merge?

[vbvbvb]

Hi all, 

Looking at following dilemma, would appreciate any advice how to achive that.

I have one table which is fetching values from external data source, let's call this table MainTable:

Some ID Number	Some Data	More Data
1234567	AAA	58
2345678	BBB	78
3456789	CCC	86
7890123	DDD	53

Then there is another 3 tables which is fetching data from another source and then appends then into 1 joined table CombinedTable , where ID values can match values from MainTable, for example:

Some ID Number	Some Data	More Data
4567890	EEE	90
3456789	CCC	86
5678901	FFF	33
2345678	BBB	78

What is easiest and most efficient way to compare values which exist in MainTable to values in CombinedTable  and keep them only if they are in MainTable , i.e final result should be:

Some ID Number	Some Data	data
3456789	CCC	86
2345678	BBB	78

So in the nutshell, commom denominator for filtering would be always ID value from MainTable since CombinedTable would always contain signifcatly more values which are not needed. 

Thanks a lot for any ideas!

[serpiva64 · Accepted solution]

Hi,

You can merge your CombinedTable with MainTable using JoinKind Inner

You obtain this

Then you can remove column MainTable

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[vbvbvb]

Thanks, but it won't make any issues since real tables I have are way more complex and contain a lot of relationships and are merged themselves?