Lost in a query...

Hi,

I have bought vData a few days ago and I cannot get the following query to work with vData.
I am sure I'm overseeing something, but I have no idea what.

I need to get the following into a profile:

SELECT CONCAT(cb_mv, " ",cb_voortitel, " ",cb_voorletters, " ",middlename, " ",lastname, " ",cb_achtertitel )
FROM mmp_j17_comprofiler
LEFT JOIN mmp_j17_invoices_contacts
ON mmp_j17_comprofiler.user_id=mmp_j17_invoices_contacts.user_id;

Any idea?

Tom

Hi,
Please let me know in which section of vData you are trying to run this Query?

Hi Danielk,

Thanks for your prompt response.

I've tried to set up a profile with export and import (reversed the query)
and with the "Quick" methode.

Tom

Hi,
You have not added table alias on the columns you are selecting to fetch.