SQL,gideview
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 = '條件 '