Have a classic master/detail situation for documents. I need a query with a following
result: for a chosen document, I need to know for each detail if there are details of same
kind followed the detail on the chosen document. In other words: if there are no details
of same kind(on other documents) which are on a chosen document, then the result is an
empty query.
ps. let say that "same kind" means that they have same code.
please advise

andrej
> Have a classic master/detail situation for documents. I need a query with
a following
> result: for a chosen document, I need to know for each detail if there are
details of same
> kind followed the detail on the chosen document. In other words: if there
are no details
> of same kind(on other documents) which are on a chosen document, then the
result is an
> empty query.
> ps. let say that "same kind" means that they have same code.

I am not completely sure what you are after.  If you have a table structure
like the following and want all detail records that  have the same
detailcode as occur in the detail records of a particular master (eg 123)
then

MasterTable
MasterId
....

DetailTable
MasterId
DetailCode
....

SELECT * FROM DetailTable WHERE MasterId <> 123 and
DetailCode IN (SELECT DetailCode FROM DetailTable WHERE MasterId=123)

John