案例分析
Select語句基本語法
SELECT select_list[INTO new_table_name]FROM table_list[WHERE search_conditions][GROUP BY group_by_list][HAVING search_conditions][ORDER BY order_list [ASC | DESC] ]
例1:
取出表YK_KCMX中符合是西藥的庫存并按拼音代碼來排列顯示
Select YK_KCMX.* ,YK_TYPK.PYDM
From YK_KCMX,YK_TYPK
Where YK_KCMX.YPXH=YK_TYPK.YPXH AND YK_TYPK.TYPE=1 Order BY YK_TYPK.PYDM