多表查询

在链接数据库提取数据时,不可避免的要用到多表查询,我选择2个表来举个例子

表1是项目图纸表,Drawing_id是主键

表2是打印表,ID是主键,

如果要取出的数据包含表1的项目,图纸,表2的申请人,打印日期,sql语句为

select t.drawing_id, d.id, t.rowid
  from project_drawing_tab t, drawingprinterqueue d
 where t.drawing_id = d.drawing_id
   and d.delete_flag = 'N'
   and d.receive_flag = 'Y'
   and d.drawingtype = '底图'

select t.project_id,t.drawing_title, d.applyname,d.printerdate, t.rowid
from project_drawing_tab t inner join drawingprinterqueue   d
on t.drawing_id = d.drawing_id
where  d.delete_flag='N'
and d.receive_flag='Y'
and d.drawingtype='底图'

2种方式时间差不多,不太清楚2者间的优劣.