Paste Description for Noel
When I select only the userid, it returns one row per user. But when I select more values it gives me all of the rows per user. How can i select all of the data I need but keep it to one row per user?
- Noel
- Wednesday, June 13th, 2007 at 10:31:04am MDT
- SELECT DISTINCT i.userid, i.invoice_id, i.invoice_date, p.duration, m.name
- FROM mi_invoices AS i
- LEFT JOIN mi_packages AS p ON p.package_id=i.package_id
- LEFT JOIN mi_members AS m ON m.userid=i.userid
- WHERE (i.package_id=1) || (i.package_id=2)
- ORDER BY i.userid, i.invoice_id DESC
advertising
Update the Post
Either update this post and resubmit it with changes, or make a new post.
You may also comment on this post.
Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.
