Perform SQL join command on these tables
CREATE TABLE CashRegister (
CashRegister_id varchar(30) NOT NULL,
Store_id varchar(30) NOT NULL,
PRIMARY KEY (CashRegister_id) );
CREATE TABLE CashRegisterTotal (
CashRegisterTotal_id varchar(30) NOT NULL,
CashRegister_id varchar(30) NOT NULL,
OpenAmount Float,
CloseAmount Float,
PRIMARY KEY (CashRegisterTotal_id),
FOREIGN KEY (CashRegister_id) REFERENCESCashRegister(CashRegister_id));
Expert Answer
An answer will be send to you shortly. . . . .