minijus
Last Activity: Jul 19 '10, 10:59 PM
Joined: Jul 19 '10
Location:
-
Well all other information for one user_id ir the same, but the cdate differs. Thank you very much for MAX(), this solved my probled because date is stored in timestamp format. -
Hello,
look here http://dev.mysql.com/tech-resources/...microsoft.html at Migration tools.Leave a comment:
-
How to select last entry when joining?
Hello,
I have a query like this:
...Code:SELECT jos_vm_orders.user_id, jos_vm_orders.cdate, sum( order_total ) AS total, count( jos_vm_orders.order_id ) AS ordercount, jos_vm_user_info.first_name, jos_vm_user_info.last_name, jos_vm_user_info.phone_1, jos_vm_user_info.user_email, jos_vm_user_info.city FROM jos_vm_orders LEFT JOIN jos_vm_user_info ON jos_vm_orders.user_id = jos_vm_user_info.user_id WHERE jos_vm_orders.order_status
No activity results to display
Leave a comment: