ab两张表:a:aid,name,address b:bid,aid,actions,actime,用1条SQL语句搜索B表,根据ACTIME字段,结果用GIDEVIEW显示:name,address,action,actime;如何实现?
------解决方案--------------------------------------------------------
SELECT a.[name], a.address, b.[action], b.actime
FROM b
INNER JOIN a
ON b.aid = a.aid
WHERE b.actime=你的值
------解决方案--------------------------------------------------------
或者
Select a.name, a.address, b.actions, b.actime
From a, b
Where a.aid = b.aid And b.actime = '條件 '