Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

comparing 2 tables columns if they match or not? Expand / Collapse
Author
Message
Posted Thursday, September 3, 2009 10:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 7:53 AM
Points: 10, Visits: 151
check if any records match
if match ---rec match/not match

when used full outer join both tables

no name ph
1 X 0
2 Y 1
3 Z 2
4 A 3

no name ph
1 X 0
2 c 6
3 m 9
4 A 5

no name ph result
1 X 0 null--------------------------why im getting nul when there are records?
2 c 6 rec found
3 m 9 rec found
4 A 5 null------------------------why im getting nul when there are records?
5 Y 1 rec found


Post #782710
Posted Friday, September 4, 2009 12:02 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 4,013, Visits: 6,098
Duplicate post. Reply here.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #782734
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse