Hi,

I have tried to join two table as follow but it give me an error:

FeedRec is Recordset

FeedRec.Open "Select * from FeedDatabase innerjoin BpDatabase on FeedDatabase.* = BpDatabase.*"

Error: Syntax error in FROM clause.

Can anyone help me?? Thank you.

Annie