--ships
Select DataShip.Name as UnitName,DataShip.ID as UnitDBID,DataShip.YearCommissioned as Year,
EnumSignatureType.Description as Band, DataShipSignatures.Front as Front,
DataShipSignatures.Rear as Rear,DataShipSignatures.Top as Top,
DataShipSignatures.Side as Sides
From ( ( DataShip 
inner join DataShipSignatures on DataShip.ID = DataShipSignatures.ID)
inner join EnumSignatureType on EnumSignatureType.ID = DataShipSignatures.Type
)
Where(DataShipSignatures.ID = UnitDBID) order by UnitName, Year, UnitDBID ASC

--subs

Select DataSubmarine.Name as UnitName,DataSubmarine.ID as UnitDBID,DataSubmarine.YearCommissioned as Year,
EnumSubmarineType.Description as UnitType,EnumSignatureType.Description as Band,
DataSubmarineSignatures.Front as Front,DataSubmarineSignatures.Rear as Rear,
DataSubmarineSignatures.Top as Top,DataSubmarineSignatures.Side as Sides,
EnumSubmarinePhysicalSize.Description as Size, DataSubmarine.Length,DataSubmarine.Beam,DataSubmarine.Height,DataSubmarine.Draft,DataSubmarine.DisplacementFull
From ( ( ( ( DataSubmarine 
inner join DataSubmarineSignatures on DataSubmarine.ID = DataSubmarineSignatures.ID )
inner join EnumSignatureType on EnumSignatureType.ID = DataSubmarineSignatures.Type)
inner join EnumSubmarinePhysicalSize on EnumSubmarinePhysicalSize.ID = DataSubmarine.PhysicalSizeCode)
inner join EnumSubmarineType on EnumSubmarineType.ID = DataSubmarine.Type
)
Where(DataSubmarineSignatures.ID = UnitDBID) 
order by UnitName, Year, UnitDBID ASC
