select jing_dian_ji_ben_table.number,
eight_du_miao_shu_table.gui_mo_yu_jie,
ping_jia_table.ming_ren_pingjia,
dian_ji_table.book_num,
from jing_dian_ji_ben_table, //就是联这四张表,每张表都有一个number的段,
//要number的值是600的记录
eight_du_miao_shu_table,
ping_jia_table,shi_cha_table,
dian_ji_table
where jing_dian_ji_ben_table.number=eight_du_miao_shu_table.number and eight_du_miao_shu_table.number=ping_jia_table.number and ping_jia_table.number=shi_cha_table.number and shi_cha_table.number=dian_ji_table.number and dian_ji_table=600
eight_du_miao_shu_table.gui_mo_yu_jie,
ping_jia_table.ming_ren_pingjia,
dian_ji_table.book_num,
from jing_dian_ji_ben_table, //就是联这四张表,每张表都有一个number的段,
//要number的值是600的记录
eight_du_miao_shu_table,
ping_jia_table,shi_cha_table,
dian_ji_table
where jing_dian_ji_ben_table.number=eight_du_miao_shu_table.number and eight_du_miao_shu_table.number=ping_jia_table.number and ping_jia_table.number=shi_cha_table.number and shi_cha_table.number=dian_ji_table.number and dian_ji_table=600
from jing_dian_ji_ben_table a left jion eight_du_miao_shu_table b
on a.number=b.number
left join ping_jia_table,shi_cha_table c on a.number=c.number
left dian_ji_table d on a.a.number=d.number
where a.number=600
select a.number,b.gui_mo_yu_jie,c.ming_ren_pingjia,d.book_num,
from jing_dian_ji_ben_table a left jion eight_du_miao_shu_table b
on a.number=b.number
left join ping_jia_table,shi_cha_table c on a.number=c.number
left dian_ji_table d on a.number=d.number
where a.number=600