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 03, 2009 10:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 06, 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 04, 2009 12:02 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:45 AM
Points: 3,949, Visits: 5,944
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