-this worked perfect! THANK YOU!

It's been a while since i've written SQL code (obviously!).

thanks again.

no worries - i appreciate you trying to keep me honest:cool:

yes, i know, but help is help. Other forums haven' been so helpful...

here's how i wrote the SQL, and error is below...thoughts?

WITH [ProductOwners]

AS

(SELECT c_id

FROM CO$prod_reg

WHERE product LIKE '%PRODUCTNAME%'

GROUP BY c_id)

SELECT CO$prod_reg.*

FROM CO$prod_reg

JOIN ProductOwners

ON CO$prod_reg.c_id = ProductOwners.c_id;

12:54:31 [WITH -...

Hi Journeyman,

Could you explain how the "WITH" statement comes into play? All the data i'm trying to pull comes from one table...registration.

Is 'ProductOwners' in your statement meant to be...