如果这是有效的选择:
选择desp goods.` case number `
,despgoods.weight
,despgoods.customer
,customers.transporttypename
来自桌面工具
inner join客户
ondespgoods.customer=customers.customer
接下来,试试这个。 插入选择结果集时,请注意没有VALUES子句。
insert into despgoods_alldetails
(case number )、weight、customer、传输类型名称)。
选择desp goods.` case number `
,despgoods.weight
,despgoods.customer
,customers.transporttypename
来自桌面工具
inner join客户
ondespgoods.customer=customers.customer