File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

simple question in mysql query

 
alsoumahi alBatal
Ranch Hand
Posts: 104
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 118
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Alsoumahi -

I think you query would look something like this



- Agad
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic