David Fenton
dfenton at ozemail.com.au
Thu Jun 24 06:25:27 CDT 2004
Gidday Gustav, What a clever solution! This is very neat, using the ABS function to get the PAX to appear or not appear depending on whether the column date is in the correct range. I can't wait to try it. Thank you heaps. I've never done a query without a join before are there any speed implications? Jim Hale referred to your example as a non-Cartesian join (is that right?) - I must do some more research! Cheers David Australia