the select statement for the WADAads_horses recordset needs to refer to both tables.
instead of:
SELECT ads_horses.* FROM ads_horses INNER JOIN tbl_posts ON ads_horses.adid = tbl_posts.postid.....
it should be:
SELECT ads_horses.*,tbl_posts.* FROM ads_horses INNER JOIN tbl_posts ON ads_horses.adid = tbl_posts.postid.....
you don't need the WADAtbl_post recordset on the page, wherever you are trying to use the WADAtbl_post recordset, you should use the WADAads_horses recordset instead.