|
примерно так, не проверял
select sum(FlxPortPcsArrival),sum(FlxNumPassengersTotalArrival),t.cruisepassangers
from flxPortJournal_1,(
select sum(FlxNumPassengersTotalArrival) cruisepassangers
from flxPortJournal_1
group by ShipsName)t
group by ShipsName
|