Help with SQL/report

Hello Informix users, I am an Informix SE user who needs some help generating a report. I have a table like this: lithology.official_name integer <------key fields top_depth real <-----/ bottom_depth real / lith_type char(6) <---/ I am trying to generate a report of all official_name that has the interval defined by the top_depth and bottom_depth intersecting the top_depth and bottom_depth of the next layer(s). For example: official_name top_depth bottom_depth lith_type ---------------------------------------------------- WELL1 0.0 6.0 SD WELL1 6.0 7.5 ML <--- this layer crosses WELL1 7.25 9.0 CL <--- this layer WELL1 9.0 14.0 SD Hope I made my problem clear. I would greatly appreciate any help and would be willing to summarize any responses I get. Thanks. Bob Moskovitz bmoskovi@consrv.ca.gov -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading