Column Join from Access to SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Column Join from Access to SQL

Author

Topic

ssis_newbee
Starting Member

8 Posts

Posted - 2011-07-15 : 03:39:10

Hi,

I have my Access table structure as follows

AccountID useralias
1 anm
2 ghy
3 reni
4 mani

I need to pass this AccountID Column and Useralias combination to AccountTeam table in SQL Server and fetch AccountTeamID
Account Team Table Structure
AccountID useralias AccountTeamID
1 anm 1
2 ghy 2
3 reni 3
4 mani 4
1 raj 5
1 rani 6
1 fella 7

If both the tables are in SQL server, i would do a join something like

SELECT
a.AccountID,at.AccountTeamID,a.UserAlias
FROM Account a
JOIN Accountteam at
on a.AccountID = at.AccountID
and a.UserAlias = at.UserAlias

I know how to do this in SQL, but not sure when both the data sources are different..

Please let me know if you need more details

Thanks in Advance

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources