SqlServer的には Select * From IdleCalacterMaster AS A Inner Join MyIdleTable AS B On A.Idle_Id = B.Idle_Id Where LoveMaxFlg = 0 Oracleだったら Select * From IdleCalacterMaster AS A, MyIdleTable AS B, FreeTradeList AS C Where A.Idle_Id = B.Idle_Id And LoveMaxFlg = 0 AND B.Idle_id = C.Idle_Id Order by C.ValuePrice かな