这个简单^_^
SELECT a.ID, a.djbh, a.csbh, b.csname, a.ygbh, d.name, a.ckbh, c.ckname, a.Fdate, a.fkfs, a.je, a.memo into 你需要的表名
FROM ((cgb AS a LEFT JOIN csb AS b ON b.id=a.csbh) LEFT JOIN ckb AS c ON c.id=a.ckbh) LEFT JOIN personnel AS d ON d.id=a.ygbh;
SELECT a.ID, a.djbh, a.csbh, b.csname, a.ygbh, d.name, a.ckbh, c.ckname, a.Fdate, a.fkfs, a.je, a.memo into 你需要的表名
FROM ((cgb AS a LEFT JOIN csb AS b ON b.id=a.csbh) LEFT JOIN ckb AS c ON c.id=a.ckbh) LEFT JOIN personnel AS d ON d.id=a.ygbh;
我试了.
这样:
SELECT a.ID, a.djbh, a.csbh, b.csname, a.ygbh, d.name, a.ckbh, c.ckname, a.Fdate, a.fkfs, a.je, a.memo into hello
FROM ((cgb AS a LEFT JOIN csb AS b ON b.id=a.csbh) LEFT JOIN ckb AS c ON c.id=a.ckbh) LEFT JOIN personnel AS d ON d.id=a.ygbh;错误信息为:
错误SQL 查询 : SELECT a.ID, a.djbh, a.csbh, b.csname, a.ygbh, d.name, a.ckbh, c.ckname, a.Fdate, a.fkfs, a.je, a.memo
INTO hello
FROM ((
cgb AS a
LEFT JOIN csb AS b ON b.id = a.csbh
)
LEFT JOIN ckb AS c ON c.id = a.ckbh
)
LEFT JOIN personnel AS d ON d.id = a.ygbh
LIMIT 0 , 30 MySQL 返回:
#1064 - 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 'hello
FROM ( ( cgb AS a
LEFT JOIN csb AS b ON b.id = a.csbh )
a.djbh,
a.csbh,
b.csname,
a.ygbh,
d.name,
a.ckbh,
c.ckname,
a.Fdate,
a.fkfs,
a.je,
a.memointo 新表名FROM
cgb AS a
LEFT JOIN
csb AS b ON b.id=a.csbh
LEFT JOIN
ckb AS c ON c.id=a.ckbh
LEFT JOIN
personnel AS d ON d.id=a.ygbh
从两个表取字段 select a.field1,a.field2,b.field1,b.field2 into 你需要的表名 from tb1 a inner join tb2 b on a.id=b.id
多个表以次类推.
where a.ID=b.ID...关键理解:连接各个表后 再从中选出所需要的字段 插入到新的表中
其实这个不难
现在是先转到MSSQL,再转到
MYSQL,轻松解决,不过还是放
200分。