Inner Join Help - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Inner Join Help

Author

Topic

masond
Constraint Violating Yak Guru

447 Posts

Posted - 2013-10-07 : 10:44:42

Hey guys

Hope all is well, I need some help.

Aim-
To find the trade_assocation_name in the SalesForce.DailyAccounts table, column account_id, and return the value in account_Name , and product a new column called test

This is my query –
SELECT
sjo.ID,
sjo.MID,
sjo.Trade_Association_Name,
do.Agent_Chain_No as Mass_Agent_Chain_No,
da.Account_ID,
da.Account_Name as Mass_Agent_Name,
CASE WHEN sjo.Trade_Association_Name collate database_default = da.Account_ID collate database_default THEN 'Same' ELSE 'Check' END AS [Indicator]
FROM Dan.Stg_Jitter_Opp sjo
INNER JOIN Dim_Outlet do ON sjo.MID collate database_default = do.FDMSAccountNo collate database_default
INNER JOIN SalesForce.DailyAccounts da ON do.Agent_Chain_No collate database_default = da.MID_Internal collate database_default
where Account_ID <> sjo.Trade_Association_Name collate database_default
and sjo.MID <> do.Agent_Chain_No
order by [Indicator] asc

masond
Constraint Violating Yak Guru

447 Posts

Posted - 2013-10-07 : 11:04:13

The query on its own would be

SELECT
sjo.Trade_Association_Name,
SalesForce.DailyAccounts.Account_Name
FROM Dan.Stg_Jitter_Opp sjo
INNER JOIN
SalesForce.DailyAccounts ON sjo.Trade_Association_Name = SalesForce.DailyAccounts.Account_ID COLLATE Latin1_General_CI_AS

but i don’t know how to incorporate that into my query above

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-07 : 23:32:14

this?


SELECT 
sjo.ID,
sjo.MID, 
sjo.Trade_Association_Name, 
do.Agent_Chain_No as Mass_Agent_Chain_No, 
da.Account_ID,
da.Account_Name as Mass_Agent_Name,
CASE WHEN sjo.Trade_Association_Name collate database_default = da.Account_ID collate database_default THEN 'Same' ELSE 'Check' END AS [Indicator],
da1.Account_Name As test
FROM Dan.Stg_Jitter_Opp sjo
INNER JOIN Dim_Outlet do ON sjo.MID collate database_default = do.FDMSAccountNo collate database_default
INNER JOIN SalesForce.DailyAccounts da ON do.Agent_Chain_No collate database_default = da.MID_Internal collate database_default
INNER JOIN
SalesForce.DailyAccounts da1 ON sjo.Trade_Association_Name = da1.Account_ID COLLATE Latin1_General_CI_AS
where Account_ID <> sjo.Trade_Association_Name collate database_default
and sjo.MID <> do.Agent_Chain_No
order by [Indicator] asc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

masond
Constraint Violating Yak Guru

447 Posts

Posted - 2013-10-08 : 03:44:27

Visakh16

Your knowledge outstands me

Well done :)
thanks you for your help

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-08 : 05:27:21

you're welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources