On Wed, 12 Nov 2003 08:14:54 +0200 "Tanz Anthrox"
<tanz_anthrox@...> wrote:

> Peter,
> How Can I combine these two Queries in only one.?
>
> Can you write a SELECT definiton for this. I tried alot, so many

trialsss

If you really, really, must have one result set, then the only way I can
think of to achieve this would be to have another intermediate table. You
would need a stored procedure to populate the table using two distinct
select statements, then take the result set from it. But this would be
pretty messy, you would need to do inserts at first, then update each row
with the second query (so you would need to know which had the greater
number and do that one first).

I can think of two alternatives (I'm assuming you are using
Delphi/C++Builder or similar),

1. Don't use data aware components - populate the grid manually using the
two seperate queries, as I have already suggested.

or

2. Use two data aware grids and place them side by side.

Regards