LeftJoin Error from value which shouldn't be accessed

MarxIt

Hi,

I'm having a hard time to get LeftJoins running with the editor.
I have two tables which should be displayed together (all values).
Model_Shop.cs is the main table and some values from Model_Main.cs should be joined/also displayed.

I tried to follow this guide: https://editor.datatables.net/manual/net/joins
but somehow I'm still getting this error: 'Unknown column 'tbl_main.id_user_edit' in 'field list''

tbl_main.id_user_edit shouldn't be accessed at all!
Only tbl_shop.id_user_edit is important in this case.
Somehow I must be understanding something wrong or overlook something.

Files are attached - to many variables to display properly in the forum.
I'd be happy if someone could help me how to display both tables at once!

Greetings
Gerrit

MarxIt

Database error which was my fault

Problem solved therefore.

allan

Thanks for posting back. Good you hear you have it working.

Allan