SELECT (
SELECT PROJECT_CONTRACT_STATION_ID
FROM project_contract_station_info
WHERE project_contract_id =3
AND station_type_id =1
) AS 'building_station_basic', (
SELECT PROJECT_CONTRACT_STATION_ID
FROM project_contract_station_info
WHERE project_contract_id =3
AND station_type_id =2
) AS 'building_station_extend'
--------------------------------------------
SELECT DISTINCT t1.project_contract_id, t1.project_contract_number, t1.project_contract_name, t1.building_entity, t1.constraction_entity, t1.contract_financing, t1.contract_filepath, t1.operate_sign, t1.sign_on_date, t1.district_id, 'project_contract_info' AS 'table_name', 'project_contract_id' AS 'xml_get_id', 'project_contract_list_id' AS 'xml_insert_id', 'project_contract_id' AS 'xml_disabled', (
SELECT t2.station_amount
FROM project_contract_info AS t1, project_contract_station_info AS t2
WHERE t2.project_contract_id = t1.project_contract_id
AND station_type_id =1
) AS 'building_station_basic', (
SELECT t2.station_amount
FROM project_contract_info AS t1, project_contract_station_info AS t2
WHERE t2.project_contract_id = t1.project_contract_id
AND station_type_id =2
) AS 'building_station_extend'
FROM project_contract_info AS t1, project_contract_station_info AS t2
WHERE (
LEFT( sign_on_date, 7 ) = '2005-08'
)
AND (
t1.project_contract_id = T2.project_contract_id
)
====================================
SELECT CASE training_manager_id
WHEN 1
THEN 'work'
WHEN 2
THEN 'abc'
WHEN 3
THEN 'ff'
ELSE 'error'
END , district_level
FROM `training_manager_info`
::::::
SELECT CASE training_manager_id
WHEN 1
THEN 'work'
WHEN 2
THEN 'abc'
WHEN 3
THEN 'ff'
ELSE 'error'
end as 'sample', district_level
FROM `training_manager_info`