RE: Having problem with query and multiple tables.

2006-05-22 Thread WebMistress
er 435-753-9008 > -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 Ac

RE: Having problem with query and multiple tables.

2006-05-22 Thread Dave Watts
> 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 Product

Having problem with query and multiple tables.

2006-05-22 Thread Michael Grove
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, C