SQL Header/detail problem
From: Hennie de Nooijer <hdenooijer_at_hotmail.com>
Date: 16 May 2002 04:26:38 -0700
Message-ID: <191115aa.0205160326.1e9f948e_at_posting.google.com>
Date: 16 May 2002 04:26:38 -0700
Message-ID: <191115aa.0205160326.1e9f948e_at_posting.google.com>
Hi i,ve a problem with a result i've to create from a header/detail
problem. under is a example given and a result. Can anybody help me
with SQL query???
In Words : For every header i have to find a detail equals the
headernumber or the than highest number lower than the headernumber.
Example
header
42
43
44
45
46
47
48
49
50
detail
17
18
19
44
45
47
48
Resultaat should be
42 19
43 19
44 44
45 45
46 45
47 47
48 48
49 48
50 48
Can anybody give me a clue??? Appreciate this
Greetz