TEMA:

Hi,

if you want to create CB view based on database, then go to Content Builder->Data Storages->and from ...or choose an existing table select your database table.

If you want to combine multiple db in one CB view, then in sql server you should to join tables in one table, and then select this one table when you create a view.

Here is described how to join three tables for example:
stackoverflow.com/questions/18642616/sql...or-3-tables/50868706
learnsql.com/blog/how-to-join-3-tables-or-more-in-sql/
www.geeksforgeeks.org/joining-three-tables-sql/

Please test it, and come back to me

If I missed something please let me know

Regards,
Tihana

Tihana,

I already created a view within my database which contains the fields I want to show in my CB view.

I can create this CB view and can select the database view as source.
But if I then try to open this CB view error is appearing:

Error 1054: Unknown column 'r.created_by' in 'field list'

Hi,

could you please post here "the code", which you used to join tables in phpmyadmin?

Regards,
Tihana

SELECT
`montafreunde_neu`.`j17_users`.`id` AS `id`,
`montafreunde_neu`.`j17_users`.`name` AS `name`,
`montafreunde_neu`.`j17_users`.`email` AS `email`,
`montafreunde_neu`.`j17_user_usergroup_map`.`user_id` AS `user_id`,
`montafreunde_neu`.`j17_user_usergroup_map`.`group_id` AS `group_id`,
`montafreunde_neu`.`j17_usergroups`.`id` AS `ug_id`,
`montafreunde_neu`.`j17_usergroups`.`title` AS `title`
FROM
(
(
`montafreunde_neu`.`j17_users`
JOIN `montafreunde_neu`.`j17_user_usergroup_map` ON
(
`montafreunde_neu`.`j17_users`.`id` = `montafreunde_neu`.`j17_user_usergroup_map`.`user_id`
)
)
JOIN `montafreunde_neu`.`j17_usergroups` ON
(
`montafreunde_neu`.`j17_usergroups`.`parent_id` = `montafreunde_neu`.`j17_user_usergroup_map`.`group_id`
)
)

Hi,

I will check it, step by step, and come back to you

If there is no answer of mine, please remind me

Regards,
Tihana