SELECT main.*, station.* FROM main Inner Join station ON main.id = station.id Inner Join species ON main.record_id =species.Record_ids where `order`='Alcyonacea' order by latitude,longitude Coral05-4(20.61697,116.88667)共20筆 CoralIN-S(20.627,116.7982)共8筆 Coral05-5(20.6757,116.9238)共22筆 Coral05-6(20.7464,116.9088)共30筆 Coral05-7(20.7802,116.8608)共41筆 Coral05-8(20.7812,116.8068)共24筆