a guest Sep 12th, 2019 89 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select l.LotNumber, i.ItemID, rfs.RFSID, i.DateSubmitted, tr.TradeName, sub.CompanyName, i.Location, i.Title, i.Description, i.Reviewed, i.InspectionRequired,
- i.Appointment, i.DateSubmitted, i.DateCompleted, i.DateClosed, i.CurrentAge, it.ItemDescription, pr.TheProblem
- from Projects p
- inner join ProjectPhases pp on p.ProjectID = pp.ProjectID
- inner join Lots l on l.PhaseID = pp.PhaseID
- inner join RequestForService rfs on rfs.LotID = l.LotID
- inner join Items i on rfs.RFSID = i.RFS
- inner join RequestTypes rt on rt.ReqTypeID = rfs.ReqTypeID
- inner join Trades tr on i.TradeID = tr.TradeID
- inner join SubContractors sub on i.SubID = sub.SubID
- inner join ItemToRepair it on i.Item2RepairID = it.Item2RepairID
- inner join Problem pr on i.ProblemID = pr.ProblemID
- where p.ProjectName = 'Alameda Landing - Linear'
RAW Paste Data