I need help, I am new to mysql and am trying to work with a table. I already have some fields called order number, orderdate, and shipdate. I am trying to create a new field called dayselapsed and have it subtract the order date from the ship date. It would need to look like this: Ordernumber Orderdate Shipdate DaysElapsed 1 1999-07-01 1999-07-03 2 2 1999-07-01 1999-07-04 3
I have no idea how to do this. Could someone include the exact commands, as I am lost? Thanks! Rachel --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php