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
> 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
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
3 matches
Mail list logo