Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do this in View.
Message
From
13/07/2003 11:49:58
 
 
To
10/07/2003 05:06:22
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00808770
Message ID:
00809654
Views:
31
Hi Noel,

try this way
SELECT ISNULL(A.NAME,B.NAME) NAME,
       ISNULL(A.TOTALSERVICE,0)+ISNULL(A.TOTALSALES,0) TOTALSALESSERVICE
FROM tablea A FULL JOIN tableb B ON B.NAME=A.NAME
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform