Re: Informix Help
}
} -=> Quoting Stuart Litel to All <=-
}
} SL> table a
} SL> x char(10)
} SL> y smallint
}
} SL> table b
} SL> x char(10)
} SL> y smallint
}
} SL> You want to find all the rows in table a were there is an "x in table
} SL> a and no coorresponding "x" in table b the query would be:
} SL> select rowid from a where x not in (select x from b)
}
} SL> Now the question - how do you find all the x and y combinations in
} SL> table a where they are not in table b.
}
} Try this:
}
} select rowid from a where x not in (select x from b)
} union
} select rowid from a where y not in (select y from b)
Can you accomplish this using
select rowid from a where (x,y) not in (select x,y from b)?
Is (x,y) a valid syntax in Informix?
}
} Bill Williams
}
} ... DOS never says "EXCELLENT command or filename"...
} ___ Blue Wave/QWK v2.12
}
}
} ----
} +------------------------------------------------------------------------+
} | Data Warp Premium BBS (713) 355-6107 HST/V.32bis |
} | Spring / Houston, Texas Multi-line, multi-gig PCBoard BBS |
} +------------------------------------------------------------------------+
}