訂單

SELECT * FROM m_OrderCall WHERE callno='CU1909170001'

--訂單

SELECT * FROM dbo.m_order WHERE callno='CU1909170001'

--明細

SELECT * FROM dbo.m_OrdList WHERE serno='OU1909170001'

--產品項目清單(規格)

SELECT * FROM m_items

--產品項目清單的

SELECT * FROM m_itemgrp

--產品項目清單(規格) + 產品項目清單的

select * from v_items where merno='A1020'

--容器歷程

SELECT * FROM m_Can

--容器清單

SELECT * FROM m_StoreDetail

--店家（瓦斯行）資料

SELECT * FROM m_store

--客戶使用中容器

select * from V_CusCanNow where stno='003' and CustNo='\306853'

--付款檔

select * from m_paydtl where serno='OU19100009'

--沖桶

select * from m_paycan

select * from m_salesh where salno='SU191000020'

select * from m_salesd where salno='SU191000020'

Created with the Personal Edition of HelpNDoc: Free EPub and documentation generator