5 | | #!sql |
6 | | select data_type.serial as type_id, data_type.name as type, maincase_new.name, maincase_new.description, |
7 | | maincase_new.loc1_lon, maincase_new.loc1_lat, maincase_new.website, maincase_new.start_time |
8 | | from data_type, maincase_new, maincase_detail |
9 | | where maincase_detail.maincase_id = maincase_new.serial and maincase_detail.type_id = data_type.serial |
10 | | order by type_id, loc1_lon, loc1_lat |
| 5 | SELECT data_type.serial AS type_id, data_type.name AS |
| 6 | TYPE , maincase_new.owner_org, maincase_new.name, maincase_new.description, maincase_new.loc1_lon, maincase_new.loc1_lat, maincase_new.website, maincase_new.start_time |
| 7 | FROM data_type, maincase_new, maincase_detail |
| 8 | WHERE maincase_detail.maincase_id = maincase_new.serial |
| 9 | AND maincase_detail.type_id = data_type.serial |
| 10 | ORDER BY type_id, owner_org, loc1_lon, loc1_lat; |
| 12 | * 資料拓墣 |
| 13 | {{{ |
| 14 | SELECT DISTINCT data_type.serial AS type_id, data_type.parent_id, data_type.name AS |
| 15 | TYPE , maincase_new.owner_org |
| 16 | FROM data_type, maincase_new, maincase_detail |
| 17 | WHERE maincase_detail.maincase_id = maincase_new.serial |
| 18 | AND maincase_detail.type_id = data_type.serial |
| 19 | ORDER BY type_id, owner_org |
| 20 | }}} |