Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Lost in a query...

More
25 Jan 2017 10:40 #3733

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Tom Kuyper
  • Tom Kuyper's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 Jan 2017 14:47 #3731

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

Please Log in or Create an account to join the conversation.

More
24 Jan 2017 14:22 #3730

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Tom Kuyper
  • Tom Kuyper's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 Jan 2017 14:00 #3727

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

Please Log in or Create an account to join the conversation.