So you are looking at the values of the object in the BL? What is wrong with the result?
In that same right-click menu, there is an option for “Show Query Script”. That will display the actual SQL that’s generated for the object – that might help you understand what it’s doing.
normally,
there is at least a long list of clientid’s
When i make a join i can see these clientid’s and then combine these with a field from the other tabele to check or the join is doing what it should.
In some casees only the client id’d show, in other cases, only the field from the other tbel show which tells me that i use the wrong type of join.
In this case, none of the 2 tables show anything at all