SELECT Lot, COUNT(*) AS Labels, SUM( IIF(received, 1, 0) AS received ;
FROM mytable ;
GROUP BY 1 ;
INTO CURSOR mycursor
>Hi guys!
>
>I have a table with the next fields:
>
>Lot --- Label ---- received
>4848 -- 001 ---- t
>4848 -- 002 ---- t
>4848 -- 003 ---- f
>4848 -- 004 ---- t
>4048 -- 005 ---- t
>4048 -- 006 ---- t
>4048 -- 007 ---- f
>
>I need a sql command that returns the next dataset:
>Lote---labels---received
>4848----4 ------ 3
>4048----3 -------2
>
>I'd really appreciate it any kind of help !
>
>Best Regards
>Martin
--sb--