Changes between Version 1 and Version 2 of Maintenance


Ignore:
Timestamp:
05/04/25 18:25:39 (13 days ago)
Author:
211301
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Maintenance

    v1 v2  
    66
    77* Се креира запис во Maintenance.
     8
     9{{{
     10INSERT INTO Maintenance (MainID, EmployeeID, ProductID, MainDate)
     11VALUES (2, 2, 2, '2025-05-04');
     12}}}
     13
     14* Преглед на направени одржувања.
     15
     16{{{
     17SELECT
     18    m.MainID,
     19    p.Model AS TruckModel,
     20    e.EmployeeName,
     21    m.MainDate
     22FROM
     23    Maintenance m
     24JOIN Product p ON m.ProductID = p.ProductID
     25JOIN Employee e ON m.EmployeeID = e.EmployeeID;
     26}}}
     27