jsp 如何同时读取两个数据表?

来源：百度知道 编辑：UC知道 时间：2024/06/08 11:16:43
jsp+access.
数据库里有两个表:
zc_qy表两个字段:nid,name
zhaopin表三个个字段:id,posName,count,addtime

要求查询出如下结果

条件:zc_qy表"nid"=zhaopin表"id"

用户单位名称(name),职位名称(posName),招聘人数(count),添加时间(addtime)

如何写sql语句查询啊?

参考

select * from 表1
union
select * from 表2
或
"Select t1.id,t1.Date,t1.Time,t1.Comments, t2.id as id2, t2.Date as date2, t2.Time as time2, t2.Comments as Comments2 From Table1 t1, Table2 t2 WHERE t1.id = t2.id ORDER by t1.id DESC"

select * from zc_qy,zhaopin where nid=id