create table Inventory( I_FlowerNumber number , I_Location varchar(20), I_Condit

Question

create table Inventory( I_FlowerNumber number , I_Location varchar(20), I_Condition varchar(20), I_Search varchar(40),I_Delete varchar(20), I_Add number,I_Quantity number,PRIMARY KEY (I_FlowerNumber));

create table vendor (V_VendorID VARCHAR(20) ,V_PhoneNumber NUMBER, V_Address VARCHAR(20), V_DirectToStore VARCHAR(10), V_Status VARCHAR(5), V_LastUpdatedBy DATE, V_Password VARCHAR(10), V_LasteUpdateTime TIMESTAMP, PRIMARY KEY(V_VendorID ) );

CREATE TABLE purchase_order (

order_number int NOT NULL,

order_name char(50) NOT NULL,

customer_address char(50),

customer_zip int, customer_city char (50),

order_total varchar(50),

v_vendorID VARCHAR(20),

ITEM_NUMBER int NOT NULL,

CONSTRAINT pk_purchase_order PRIMARY KEY (order_number),

FOREIGN KEY (V_VendorID) REFERENCES vendor(V_VendorID),

FOREIGN KEY (ITEM_NUMBER) REFERENCES Inventory(I_FlowerNumber)

);

Command for joining the tables with the above sql commands??

How to join commands above?

Explanation / Answer

SELECT purchase_order.order_number, Inventory.I_FlowerNumber, purchase_order.order_name
FROM purchase_order INNER JOIN Inventory ON purchase_order.ITEM_NUMBER=Inventory.I_FlowerNumber;

SELECT purchase_order.order_number, vendor.V_DirectToStore, purchase_order.order_name
FROM purchase_order INNER JOIN vendor ON purchase_order.V_VendorID=vendor.V_VendorID;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.