Having problem with query and multiple tables.

I have a query calling on data in multiple tables. The database is MS Access. Here is the query that I am using SELECT p.name, p.product_id, p.content_id, p.creationdate, h.hits AS hits, h.clickthroughs AS clicks, s.pagetitle, s.parent, c.pagetitle AS category FROM Products p, Product_Hits h,

RE: Having problem with query and multiple tables.

I have a query calling on data in multiple tables. The database is MS Access. Here is the query that I am using SELECTp.name, p.product_id, p.content_id, p.creationdate, h.hits AS hits, h.clickthroughs AS clicks, s.pagetitle, s.parent, c.pagetitle AS category FROM Products p,

RE: Having problem with query and multiple tables.

-Original Message- From: Michael Grove [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 12:15 PM To: CF-Talk Subject: Having problem with query and multiple tables. I have a query calling on data in multiple tables. The database is MS Access. Here is the query that I am using