1. Engineering
  2. Computer Science
  3. perform sql join command on these tables create table cashregister...

Question: perform sql join command on these tables create table cashregister...

Question details

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) REFERENCES CashRegister(CashRegister_id));

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution