Re: SQL question combine 3 queries into 1?

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Art,

Maybe something like

select substr(tlc, 1, 1), sum(qty)
  from legmov
 where drvrid = 180481089
   and substr(tlc, 1, 1) in ('1', '6', '9')
 group by substr(tlc, t1, 1);

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx t/


On 6/11/2024 8:08 AM, Art Tostaine, Jr. wrote:
> I have these 3 queries that give me a qty for each type of location.  Is it
> possible to get the value of all 3 sum(qty)'s in 1 query?
>
> Thank you
>
> -- tables
> select *sum*(qty) table from legmov
> where drvrid = *180481089*
> and *substr* (tlc,*1*,*1*) = '9';
> -- problem
> select *sum*(qty) problem from legmov
> where drvrid = *180481089*
> and *substr* (tlc,*1*,*1*) = '6';
>
> *-- Staging*select *sum*(qty) Staging from legmov
> where drvrid = *180481089*
> and *substr* (tlc,*1*,*1*) = '1';