Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
aggregate on varchar |
Thu, Aug 9 2007 8:22 AM | Permanent Link |
mohsen aghajani | 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 |
Thu, Aug 9 2007 2:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |