Re: Another SQL question

(Mr. John C. Flack) writes:
>Try doing this:
>

 [deleted for brevity]
>
>OR in Oracle 7.2 and beyond:
>select year, car, color, sum(car_count)
> from (select year, car, color, 0 car_count
> from yr_model, cars
> where year=94
> union
> select year, car, color, 1
> from inventory
> where year=94)
> group by year, car, color;

  This one worked beautifully and gave me the performance I was looking   for. a couple of notes:

• In the second inner select, I needed a "COUNT(field) car_count" instead of "1"
• I needed a group by clause for that same select statement, as well as for the outer select. Thanks a lot for the help. -- Amine. atarhini_at_ringer.cs.utsa.edu

The above views are mine only ... etc. etc. Received on Tue Jul 30 1996 - 00:00:00 CEST