Look at marts link again. The SQL is for any db, Access included.
What I think you want to do is a Left Join - where all rows from the first table are listed along with any rows from the second table that match on a specific key.
The two basic problems with your sql is that it's not identifying which table the fields are coming from and we don't know what key field the two tables have in common that can be used to link them.
- Each field you specify in the sql needs to be in the format of tablename.fieldname - e.g. T_WEBLOG.b_published
- You need to join the two tables on some key field that is in both tables - e.g. Log_ID, WebLog_Count, ... whatever.
Topic Options
Post Options
Thanks(0)
