|
Advance Member
|
引用:
Originally posted by 黑狗弟
再問各位大大一題...
-----------
Select
Trips.trip_id,
Planetypes.name,
Trips.plane_id,
Planetypes.max_passengers,
Count(Trips.trip_id) carried
From boardingpass, trips, planes, planetypes
Where
Boardingpass.trip_id = trips.trip_id and
trips.plane_id = planes.plane_id and
planes.planetype_id = planetypes.planetype_id and
carried > Planetypes.max_passengers
group by
Trips.trip_id,
Planetypes.name,
Trips.plane_id,
Planetypes.max_passengers
Order by Trips.trip_id
-----------
中間這行
carried > Planetypes.max_passengers
-------------
其實我想要的是把我原先在第 6 行的
-------
Count(Trips.trip_id) carried
-------
的這個數帶進來 where 下面...
可是他說 invalid column...
或者在 where 下面放
-------
Count(Trips.trip_id)
------
他也說不行... @_@
請問各位大大有什麼辦法嗎???
我該放什麼 statement??
我想過在放多個 (select ) 當作 subquery..
不過題目說.. 只能放一個 select statement..
|
group by ...... having Count(Trips.trip_id) > Planetypes.max_passengers |