Re: how... concat group by?

If there is a function to sum values, why there isn't one to sum strings i.e. concat strings. Or how should i use it? You use concat to put two strings together. I know, i have read the manual. /concat('string1','string2')/, but it doesn't works with group by. I would like to get this: 1

how can i make it?

For example i have 3 tables (really i have to make it with 6 tables, but...) So 3 tables: Table1 uid| name 1user1 2user2 3user3 Table2 iduidc 1150 2123 3142 4223 52303 Table3 idctxt 123'twenty-three' 242

Re: how can i make it?

Of course left join. And group by moreover. But how? For the group by i need a sum-like function, which joins the strings. how can i get a recordset constains all records (or records matching a where exp.) from the Table1 with the c values from the Table2, like this: uidnamecs

Re: how can i make it? concat?

It's a bad habbit to cc to a list. Ooops. Sorry. Of course left join. And group by moreover. But how? For the group by i need a sum-like function, which joins the strings. Hmmm, something like concat() you mean? I tried it. Doesn't works. Without group by i have this set: idnamec

how can i make it?

For example i have 3 tables (really i have to make it with 6 tables, but...) So 3 tables: Table1 uid| name 1user1 2user2 3user3 Table2 iduidc 1150 2123 3142 4223 52303 Table3 idctxt 123'twenty-three' 242

count distinct

I can make this query: select a from table. I can count it: select count(a) from table. I can select it: select distinct a from table. But how can i count it? select count(distinct a) from table doesn't works Z - Before