I have 2 table with 1 related field. Main table keeps contents and second one keeps tags
about contents.
Each tag is in one record.
I want to use one query to get a content from first table and all of it's related tags
beside it as varchar field.
Aggregate functions do not work on varchar fields so how I can do that

Mohsen,

<< I have 2 table with 1 related field. Main table keeps contents and second
one keeps tags about contents.  Each tag is in one record. I want to use one
query to get a content from first table and all of it's related tags beside
it as varchar field.  Aggregate functions do not work on varchar fields so
how I can do that >>

What you want is an aggregate function that concatenates the values
together, and unfortunately DBISAM does not have such an aggregate function.
Therefore, you're going to have to run the query and create a temporary
table manually that you can use to format the query result set and append
the formatted results into.

--
Tim Young
Elevate Software
www.elevatesoft.com