What is the purpose of the join? I think I know what you are trying to do
so make the first query a sub query and join the subquery to the carello
table.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com -
On 26 Jun 2003 at 15:07, gerald_clark wrote:
> The second query contains a join and may have many times more rows in
> the result set.
[snip]
> >++-+--++--+
> >| date1 | sum1| sum2 | cod| fromprev |
> >++-+--+
Why would you expect they should have the same results?
The second query contains a join and may have many times more rows in
the result set.
PaT! wrote:
Dear All,
I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query 2
