就是关于在两张表中的数据查找问题

csv:

表1::cityname  字段1:fac     字段2:faccode

表2:cityfac    字段1:factory 字段2:faccode

实现--->输入关键字:地址.即显示该工厂对应号码.

取得关键字:

var keys

keys=request.form("keys")

sql="select faccode from cityname as a inner join cityfac as b"

sql=sql&" on a.faccode=b.faccode "

sql=sql&"where b.factory like '"&keys&"%'"

================看了吓一跳.是PHP论坛.=============

修改如下.

$keys=$_POST['keys'];

$sql="select faccode from cityname as a inner join cityfac as b";

$sql=s$ql." on a.faccode=b.faccode ";

$sql=$sql."where b.factory like '"&keys&"%'";

===============个人意见.保留.觉得两个表最好有个共同字段.通过建立关联进行查询数据.

[[it] 本帖最后由 sunfishy 于 2008-10-19 16:26 编辑 [/it]]