数据库中的2个记录集怎么连接

就是调用记录集A，调用条件记录集A中有1列是等于记录集B的一列
$query_RecordsetA= "SELECT * FROM member WHERE username like ' $row_RecordsetB['author'] '";我这样写报错了

注意+那里试字符串连接符，看看你什么语言，做对应调整

 "SELECT * FROM member WHERE username like '"   +       $row_RecordsetB['author']       +   "' "