|
|
|
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
SELECT T.type_name From T1_User.User_company as UC left join T1_User.Company as C using(com_num)left join T1_User.Company_type as T using(type_num) WHERE UC.user_num= |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND order_type=4' at line 1 |
SELECT count(*) From T1_Orders.Order WHERE user_num= AND order_type=4 |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
SELECT count(*) From T1_Estimate.Estimate WHERE user_num= |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
SELECT sum(OP.order_price+OP.order_tprice+OP.order_tvprice+OP.order_commission) From T1_Orders.Order as O, T1_Orders.Order_price as OP WHERE O.order_num=OP.order_num and O.order_type in (4) AND O.user_num= |
0원 |
|
|
|
|
|
|
|
|
|
|
|
|
순번 |
일련번호 |
날짜 |
상품명 |
공급가액 |
세액 |
합계금액 |
출력상태 |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY T.tgroup
ORDER BY T.tdate DESC' at line 8 |
SELECT
T.tgroup, T.tdate,
O.order_num, O.wdate, C.com_code,
TL.date as log_date,
TH.hiworks_code FROM T1_Account.Tax as T left join T1_Orders.Order as O using(order_num) left join T1_Orders.Order_tax as OT using(order_num) left join T1_User.Company as C using(com_num) left join T1_Account.Tax_log as TL using(tgroup) left join T1_Account.Tax_hiworks as TH using(tgroup)
WHERE O.user_num=
GROUP BY T.tgroup
ORDER BY T.tdate DESC |
발행된 세금계산서가 없습니다. |
|