simple question in mysql query

[alsoumahi alBatal]

Hi guys I have something like this in my mysql table , I would like to get a resultset of how many spools completed( fitup joint completed and welding joint completed)
one spool considers completed if all joints under that spool completed for both fitup and welding completed

DrawingNo spoolNo jointNo fitup welding

Draw 1 Spool 1 Joint 1 completed completed
Draw 1 Spool 1 Joint 2 completed
Draw 1 Spool 2 Joint 1 completed completed
Draw 1 Spool 2 Joint 2 Completed completed

Draw 2 Spool 1 Joint 1 completed completed
Draw 2 Spool 2 Joint 1
Draw 2 Spool 3 Joint 1 completed

Draw 3 Spool 1 Joint 1 completed completed

in this case only draw3 spool1 is completed

please help me guys

[Agador Paloi]

Alsoumahi -

I think you query would look something like this

            SELECT
                t.draw,
                t.spool
            FROM
                t_weld t    
            WHERE
               t.draw not in 
                 (  select draw  as i_draw
                    FROM
                        t_weld
                    where
                        fitup is   null  or
                       welding  is  null )


       

- Agad