hw acc - 5 Bolden Wire and Cable Co 500 Copper#22AWG 10...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SELECT a.vendorname as vendor, b.materialsinventorydescription, b.quantity from step1 as a inner join step3 as b on a.purchaseordernumber = b.purchaseordernumber Tables I made to find my answer step1 SELECT a.VendorName, b.PurchaseOrderNumber INTO step1 FROM tblvendor_data AS a INNER JOIN tblpurchaseorder_data AS b ON a.VendorNumber = b.VendorNumber Query3 vendor materialsinventorydescription Quantity US Electrical Controls 120v 40a 100 US Electrical Controls DPDT 240v 100a 50 US Electrical Controls SPDT 240v 100a 100 Witchita Relays, Inc. SPDT 120v 40a Silver 30 Witchita Relays, Inc. TPST 240v 100a Mercury 20 Pirozolli Supply, Inc. F 240v 100a solderless 100 Pirozolli Supply, Inc. M 120v 40a clip 50 Bomac Sheet Metal Co. 1/4" Steel 4x4 sheet 100 Bomac Sheet Metal Co. 1/8" Steel 4x4 sheet 200 US Electrical Controls 240v 40a 50 Bolden Wire and Cable Co. 500' Copper Twin #18AWG
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 5 Bolden Wire and Cable Co. 500' Copper #22AWG 10 Pirozolli Supply, Inc. M 120v 40a clip 200 Query1 Name P.O. Number US Electrical Controls 100001 Witchita Relays, Inc. 100002 Pirozolli Supply, Inc. 100003 Bomac Sheet Metal Co. 100004 US Electrical Controls 100005 Step3 SELECT a.MaterialsInventoryDescription, b.PurchaseOrderNumber, b.[PurchaseOrder-Materialsinventoryquantity] as quantity into step3 FROM tblmaterialsinventory_data AS a INNER JOIN [tblPurchaseOrder-MaterialsInventory_Data] AS b ON a.MaterialsInventoryStockNumber = b.MaterialsInventoryStockNumber; Query2 Description P.O. Number Quantity 1/8" Steel 4x4 sheet 100004 200 1/8" Steel 4x4 sheet 100012 50 DPDT 240v 100a 100001 50 500' Copper #22AWG 100006 10 500' Copper #22AWG 100009 20...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

hw acc - 5 Bolden Wire and Cable Co 500 Copper#22AWG 10...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online