You have two tables: CustTable and CustTrans. CustTrans has a foreign key relation with CustTable on the "AccountNum" field. Multiple CustTrans records refer to a single CustTable record. Each…

You have two tables: CustTable and CustTrans. CustTrans has a foreign key relation with CustTable on the "AccountNum" field. Multiple CustTrans records refer to a single CustTable record. Each CustTrans record can refer to a single CustTable record. You want to write code to display records of customers and their corresponding transactions. You need to display the following fields:

AccountNum from CustTable table CustGroup from CustTable table AmountCur from CustTrans table Finally, you want to select only the approved transactions. An approved transaction is a CustTrans record where the value of the Approved field is NoYes::Yes. You need to choose the data that meets these requirements. Which select statement should you use?