Oracle journey (ii) SQL statement query settings such as t_chmo_order_opera p, business table t_chmo_teruser u, user table t_chmo_province, Province table t_chmo_opera_price r price list ----- value-added business details select p. oo_source_num as phone number, r. opera_price as amount, cp_province_name as region, p. oo_create_time as date, u. ct_category as operating system, r. new_name as handles business from t_chmo_order_opera p, t_chmo_teruser u, t_chmo_province, t_chmo_opera_price r -- queries where p in conjunction with four tables. oo_create_time> = to_date ('1970-01-27 00:00:00 ', 'yyyy-mm-dd hh24: mi: ss') -- use the time and p of the business table. oo_create_time <= to_date ('2017-02-02 23:59:59 ', 'yyyy-mm-dd hh24: mi: ss ') and oo_status = '1' --- oo_status in the business table is equal to 1, indicating that the business is successful and po_name is not null -- the business name is not equal to null and po_name = opera_name --- the business name in the business table matches the business in the price list name, then we can get the price in the price list and oo_source_num = ct_phone --- associate the phone number in the business table with the phone number in the User table and oo_province_code = cp_province_code -- the province code in the business table is equal to the province table code, then, the query results of the Chinese name of the province are as follows: