我正在使用AllenBrowne Concat相关函数，但无法正常工作 [英] I am using AllenBrowne Concatrelated function and it's not working

问题描述

我的查询需要帮助.

我的数据如下:

表:妈妈

mom_name  
Alice  
Christina  
Mandy  

儿童餐桌:

mom_name    kid_name
Christina   Charles
Christina   Jack
Alice       Mandy
Alice       Joe
Alice       Jeff
Mandy       Alan
Mandy       Omar

我正在输入此查询

SELECT distinct Moms.mom_name, 
concatrelated("[kid_name]","[kids]","mom_name = " & [moms.mom_name] & """" ) AS Expr1
FROM Moms ;

我收到此错误:

Error 3075: Syntax error in string in query expression 'mom_name = Alice"'.

该错误重复出现在表中的每个妈妈名字上.我的错误在哪里?

and the error repeats over every mom name in the table.. where is my mistake??

推荐答案

可能是:

Select Distinct 
    Moms.mom_name, 
    ConcatRelated("[kid_name]","[kids]","mom_name = '" & [moms.mom_name] & "'") AS Kids
From 
    Moms;

这篇关于我正在使用AllenBrowne Concat相关函数，但无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！