Hello everyone!
My problem is : I have a form stored in a database "data_trainings" with a database join in multi select to select companies from my database "data_companies". (the id of companies is stored in a repeat database "data_trainings_repeat_training_place") I have another form in which I will select those companies. So, in concat label I tryed these code:
My code shows an error...
When I do these query in mysql :
all is OK... Why?
Thank you for helping me!!!
My problem is : I have a form stored in a database "data_trainings" with a database join in multi select to select companies from my database "data_companies". (the id of companies is stored in a repeat database "data_trainings_repeat_training_place") I have another form in which I will select those companies. So, in concat label I tryed these code:
Code:
(SELECT DISTINCT company_sign FROM data_trainings_repeat_training_place, {thistable}, data_companies WHERE data_companies.id = data_trainings_repeat_training_place.training_place AND data_trainings_repeat_training_place.parent_id = {thistable}.id),' ',{thistable}.training_title_action
When I do these query in mysql :
Code:
SELECT DISTINCT
data_companies.company_sign
FROM
data_trainings_repeat_training_place,
data_trainings,
data_companies
WHERE
data_companies.id = data_trainings_repeat_training_place.training_place
AND data_trainings_repeat_training_place.parent_id = data_trainings.id
Thank you for helping me!!!