Hi Friends.,
select distinct R.PRE_DIR,R.ST_NAME,R.ST_TYPE,R.SUF_DIR from GcRange R
Left Outer Join GcRange L on
L.OBJECTID != R.OBJECTID and
IsNull(L.PRE_DIR, '') = IsNull(R.PRE_DIR, '') and L.ST_NAME = R.ST_NAME and IsNull(L.ST_TYPE, '') = IsNull(R.ST_TYPE, '') and IsNull(L.SUF_DIR, '') = IsNull(R.SUF_DIR, '')
and L.FROMLEFT <> 0 and L.TOLEFT <> 0 and L.FROMRIGHT <> 0 and L.TORIGHT <> 0
where
L.ST_NAME is null
and R.FROMLEFT = 0 and R.TOLEFT = 0 and R.FROMRIGHT = 0 and R.TORIGHT = 0
the above is my query...i couldn't use this in sql command of Excel source....it says something like this " wrong number of values passing the arguments isnull(L.PRE_DIR, '') "
can any one help me pls?