Access sql to T-SQL - 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

Access sql to T-SQL

Author

Topic

rizo
Starting Member

16 Posts

Posted - 2012-03-02 : 05:49:57

Hi Guys,

first post, pls be kind!!

My problem is with the access SQL below.


SELECT DISTINCT *
FROM Contacts_Raw LEFT JOIN Suppress ON Contacts_Raw.EmailAddress = Suppress.EmailAddress
WHERE (((nz([Contacts_Raw].[emailaddress]))<>nz([suppress].[emailaddress])));

How do I do the below in SQL Server 2008?

WHERE (((nz([Contacts_Raw].[emailaddress]))<>nz([suppress].[emailaddress])))"

I've attached a link to the pic of how it is in access.
[url]http://imageshack.us/photo/my-images/820/sqlpic.png/[/url]

cheers guys

rizo

rizo
Starting Member

16 Posts

Posted - 2012-03-02 : 09:58:06

SOLVED

rizo

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources