Select 
  W.FIO, 
  T.PLANTYPENAME, 
  I.CONTENT, I.BUDGET, I.DATEBEG, I.DATEEND, I.DATEFIN, I.DESCRIPT,
  P.IDWORKPLAN, I.IDWORKPLANITEM, I.FLAGSOLID, P.NUMBER,
   0  As TOTAL, 
  Null As PERCENTY, 
  Null As PERCENTN 
From 
  WORKPLAN P Left Outer Join WORKPLANITEM I 
   On I.IDWORKPLAN =  P.IDWORKPLAN 
     Left Outer Join WORKPLANTYPE T 
     On T.IDWORKPLANTYPE = I.IDWORKPLANTYPE 
      Left Outer Join WORKERS W On W.NUMBER = P.NUMBER 
Where I.DATEEND Between :DATESTART And :DATECANC
Union All
Select 
  W.FIO, 
  '' As PLANTYPENAME, 
  '' As CONTENT,  0  As BUDGET, 
  Null As DATEBEG, 
  Null As DATEEND, 
  Null As DATEFIN, '' As DESCRIPT,
   0  As IDWORKPLAN,  0  As IDWORKPLANITEM, 
  False As FLAGSOLID, P.NUMBER,
   1  As TOTAL,  0  As PERCENTY,  0  As PERCENTN 
From 
  WORKPLAN P Left Outer Join WORKPLANITEM I 
   On I.IDWORKPLAN =  P.IDWORKPLAN 
     Left Outer Join WORKPLANTYPE T 
     On T.IDWORKPLANTYPE = I.IDWORKPLANTYPE 
      Left Outer Join WORKERS W On W.NUMBER = P.NUMBER 
Where I.DATEEND Between :DATESTARTP And :DATECANCP 
Order By FIO, TOTAL