你的sql语法不对,要用连接,两张表没有连接....
where bk_inf.bk_name like "%编程%"
and bk_inf.id =* bk_brw.id请查询access的外连接语法,我忘了。我使用的是sql2000的语法而且不知是否正确。
where bk_inf.bk_name like "%编程%"
and bk_inf.id =* bk_brw.id请查询access的外连接语法,我忘了。我使用的是sql2000的语法而且不知是否正确。
解决方案 »
- Repeater导出EXCEL
- 有谁用过DevExpress 的ReportToolbar能与CrystalReport 连起来吗?
- ASPX2.0中 App_Data目录起什么作用?可以放置数据库吗?
- 线程默认多长时间超时呢?
- VS.net 2003安装问题?(给分)
- 100分求购光盘:章立民的《用实例学ASP.NET-使用VB.NET与ADO.NET》,有该光盘的请帮一下忙,谢谢!!!
- 请教有关页面跳转的小问题
- 一个很烦人的问题
- 瀑布流后台实现的问题
- 关于TreeView的问题
- 由谁能做到http://www.dbstep.com/Products/Demo/iWebOffice2000/Ocxasp/DocumentList.asp这个,源代码可以购买!
- 帮忙!有人装了windows 2003的sharepoint service么?
from bk_inf, bk_brw
where bk_inf.bk_name like "%编程%"
from bk_inf, bk_brw
where bk_inf.bk_name like "%编程%"
and bk_inf.id=bk_brw.id
from bk_inf left join bk_brw on bk_inf.id = bk_brw.bk_per.id
where bk_inf.bk_name like "%编程%"
from bk_inf, bk_brw
where bk_inf.id=bk_brw.id and bk_inf.bk_name like "%编程%"
Select bk_inf.id, bk_inf.bk_name, bk_brw.bk_per
from bk_inf,
left outer join bk_brw
on bk_inf.id=bk_brw.id
where bk_inf.bk_name like "%编程%"
from bk_inf bk_brw
where bk_inf.id = bk_brw.bk_per.id
bk_inf.bk_name like "%编程%"
from bk_inf left out join bk_brw on
where bk_inf.bk_name like "%编程%"
A0002 C#编程思想
B0002 J#基础编程 李四再帮帮我吧!!!!!