Question: Raw _ Materials has the follwing fields: Raw _ Materials _ Code, Raw _ Materials _ Description, Raw _ Materials _ Price; Purchase _ orders
RawMaterials has the follwing fields: RawMaterialsCode, RawMaterialsDescription, RawMaterials Price; Purchase orders has the follwing fields: PurchaseOrderID PurchaseOrderDate, PurchaseEmployee ID SupplierID RawMaterialsCode, QuantityPurchased, RawMaterialPurchasePrice; Suppliers has the follwing fields: SupplierID SupplierCompanyname, SupplierAddress, SupplierCity, SupplierSt SupplierZip, SupplierPhone, Notes
Relying on the primary keyforeign key relationships, how would you create a SQL query that would select all the data from both the PurchaseOrders table and the Suppliers table?
Relying on the primary keyforeign key relationships, how would you create a SQL query that would select all the data from both the PurchaseOrders table and the RawMaterials table?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
