Re: Help with SQL/report
On Tue, 19 May 1998 20:51:52 GMT, dgwilson@gte.net (Douglas Wilson)
wrote:
>This might work (if your data is as I think it is):
>select *
>from lithology a
>where exists
>(select 1
> from lithology b
> where
> (a.top_depth between b.top_depth and b.bottom_depth or
> a.bottom_depth between b.top_depth and b.bottom_depth)
> and a.lith_type != b.lith_type
and a.official_name=b.official_name
>)>
>Hope that helps,
>Douglas Wilson