Insert Into FolioBillingDetail Select FolioNo,TransactionCode,TransactionSubCode,BalanceCode,'System',Now()
From FolioBalance Inner Join SpecialBillingDetailConfig Using(BillingGroupCode)
Where FolioBalance.BillingGroupCode<>'';
提示下面错误!
ERROR 1064 (42000): 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 'Inner join specialBillingDetailConfig using(BillingGroupCode) ce.billinggroupcod' at line 1
请高手指点
From FolioBalance Inner Join SpecialBillingDetailConfig Using(BillingGroupCode)
Where FolioBalance.BillingGroupCode<>'';
提示下面错误!
ERROR 1064 (42000): 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 'Inner join specialBillingDetailConfig using(BillingGroupCode) ce.billinggroupcod' at line 1
请高手指点
insert into tbl_name(cols,....) select .......
谁说语法对了??
Insert Into FolioBillingDetail Select FolioNo,TransactionCode,TransactionSubCode,BalanceCode,'System',Now()
From FolioBalance Inner Join SpecialBillingDetailConfig Using(BillingGroupCode)
Where FolioBalance.BillingGroupCode <>'';'System' 加引号是什么意思
还有Insert Into FolioBillingDetail()没加字段
怎么晓得插入到那个列???
MYSQL MS SQLSERVER ORACLE 他们都没那么神奇