Lost in a 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,

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