Hello everyone I am trying to figure out a question that i just can't get the answer to i hope that someone can help. Ok
I need to look at entries in a database for all transactions on a certain date. Transactions are recorded in two tables, ‘transactions’ containing data about the transaction generally, and transaction_item, which holds each line item in a transaction. The common field (foreign key in the transaction_item table) that relates the two tables is ‘trans_id’. Show a SELECT query that will retrieve the following fields in each row of the result: From ‘transaction’, the trans_date, trans_total, and payment_method columns; from transaction_item, price and item_code and i have to join the two tables appropriately.
Any help would be greatly appreciated. Thanks in advance for any help.