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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-12 : 09:25:48
|
| Senthil writes "Can anyone please help me in converting this Access Query toSQL Server query?SELECT [Network Nodes].CALL_SIGN, [Network Nodes].CALL_ID, [Sites Information].CITY, [Network Nodes].NODE_ID, [Sites Information].STATE, [Sites Information].METRO, [Sites Information].ORG_NAME, [Sites Information].ORG_TYPE, IIf(IsNull([ISDN Data].STATUS),'',[ISDN Data].STATUS) AS Status, ([Network Nodes].NODE_ID=[ISDN Data].BASIC_NODE) AS DartSite, [ISDN Data].LNK_TYPEFROM [ISDN Data] RIGHT JOIN ([Sites Information] INNER JOIN [Network Nodes] ON [Sites Information].SITE_CODE = [Network Nodes].SITE_CODE) ON [ISDN Data].ISDN_ID = [Network Nodes].ISDN_IDWHERE [Sites Information].STATE='ACT' AND [Sites Information].METROORDER BY CITY;" |
|
|
|
|
|
Convert Access Query to SQL Server