多表联合left join
select p.*,c.*,sc.*, se.*
from ((p left join c on p.channel=c.channel) left join sc on p.channel=sc.channel) left join se on p.channel=se.channel;
mysql导入数据
load data local infile '$WORK_HOME/date.dat' into table search fields terminated by '\t';
本文来自博客园,作者:茄子_2008,转载请注明原文链接:https://www.cnblogs.com/xd502djj/archive/2012/10/23/2736057.html