Results 1 to 6 of 6

Thread: [RESOLVED] help looping my select statment

Threaded View

  1. Aug 25th, 2016, 07:32 PM #1
    kebo
    kebo is offline

    Thread Starter
    Still learning kebo's Avatar
    Join Date
    Apr 2004
    Location
    Gardnerville,nv
    Posts
    3,762

    Resolved [RESOLVED] help looping my select statment

    hey all,
    I have this...

    Code:
    select company,sum(minutes) from production_table as A
right join customers as C
on A.customerID=C.id 
where C.id=1
    That returns a single row where c.id=1. How do eliminate the c.id=1 and return a row for every customer?

    I'm using mysql if it matters
    thanks
    kevin
    Last edited by kebo; Aug 25th, 2016 at 07:39 PM.
    Process control doesn't give you good quality, it gives you consistent quality.
    Good quality comes from consistently doing the right things.
    Vague general questions have vague general answers.
    A $100 donation is required for me to help you if you PM me asking for help. Instructions for donating to one of our local charities will be provided.

    ______________________________
    Last edited by kebo : Now. Reason: superfluous typo's
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width