daniellemacey

SELECT customer.id_customer, customer.firstname, customer.lastname, orders.id_order, order_history.date_add FROM customer, orders, order_history WHERE customer.id_customer = ? AND customer.id_customer = orders.id_customer AND orders.id_order = order_history.id_order ORDER BY order_history.date_add ASC LIMIT 1;

bcnf is very uncommon, i wouldnt worry about that too much

you need to specificy the table you're using

use where clause

you can always SELECT SUM()

Hi, I'm not sure how to add two-digit input and three-digit output capacity to the program attached. ; Filename SubTest3.asm ; This program is designed to demonstrate the use of subroutines in ; programming. ; This file is phase 3 and introduces a multiply subroutine. ; Current support subroutines include …