Listed below are some random queries generated to simulate the types of inquiries users of EasyMainsaver may pose (these queries can also be found in the Access file).
[1] Retrieve all Room IDs for all items supplied by Bosch:
SELECT LOCATIONS.Room_ID, STOCK_ITEMS.Description, VENDORS.Name
FROM VENDORS RIGHT JOIN (LOCATIONS INNER JOIN STOCK_ITEMS ON LOCATIONS.Loc_ID = STOCK_ITEMS.Location) ON VENDORS.Vendor_ID = STOCK_ITEMS.Vendor_ID
WHERE (((VENDORS.Name)="Bosch"));
[2] Retrieve all vendors and the total number of separate items they supply:
SELECT VENDORS.Name, Count(STOCK_ITEMS.Stk_No) AS CountOfStkItems
FROM VENDORS, STOCK_ITEMS
WHERE (((VENDORS.Vendor_ID)=[STOCK_ITEMS].[Vendor_ID]))
GROUP BY VENDORS.Name;
[3] Retrieve all stock items that don't yet have a matching location (this query is helpful for new items that are sitting on the receiving dock awaiting a formal localization):
SELECT DISTINCTROW LOCATIONS.Loc_ID, STOCK_ITEMS.Stk_No
FROM STOCK_ITEMS, LOCATIONS
WHERE (((LOCATIONS.Loc_ID)="WH1"));
[4] Retrieve all cabinet locations where parts for “Aseptic Form/Fill/Seal” machines are kept:
SELECT EQUIPMENT.Name_Of_Equip, STOCK_ITEMS.Stk_No, LOCATIONS.Cabinet, EQUIPMENT.Equip_No
FROM (LOCATIONS INNER JOIN STOCK_ITEMS ON LOCATIONS.Loc_ID = STOCK_ITEMS.Location) INNER JOIN EQUIPMENT ON STOCK_ITEMS.Stk_No = EQUIPMENT.Stk_No
WHERE (((EQUIPMENT.Equip_No)="001-000"));
[5] Retrieve all items delivered or promised to be delivered in 2001; include: name of equipment, part number, description and promised date.
SELECT EQUIPMENT.Name_Of_Equip, STOCK_ITEMS.Part_No, STOCK_ITEMS.Description, ORDER_POINT.Date_promised
FROM ORDER_POINT INNER JOIN (STOCK_ITEMS INNER JOIN EQUIPMENT ON STOCK_ITEMS.Stk_No = EQUIPMENT.Stk_No) ON (EQUIPMENT.Stk_No = ORDER_POINT.Stk_No) AND (ORDER_POINT.Stk_No = STOCK_ITEMS.Stk_No)
WHERE (((ORDER_POINT.Date_promised)>=#1/1/2001#));
Industrial Maintenance pages:
Industrial Preventive Maintenance (PM) FAQ | Choosing Computerized Maintenance Management Software (CMMS) | Maintenance Management Books