Re: If and Time Statements

[Peter Brawley]

Quote

I would like to bring in: Order Status, Time Elapsed Minutes, Created Date, Created Time, Accepted By Store, Minutes To Accepted By Store, Invoiced At, Mins Elapsed Invoiced, Driver Accepted, Mins Driver Accepted, Driver At Store, Mins Driving To Store, Mins Driver In Store, Driver Starts Delivery, Driver Arrival At Client, Mins Driving To Client Driver Completes Delivery, Total Mins Elapsed To Delivery

Are those column names? If so, the spaces in them will raise endless issues. Best practice: avoid illegal chars in database object names.

Apart from that, if we're to help with adding these columns to your query, we'll need to see the result of ...

show create table order;