In a browse it should ‘Just Work’.
I assume you mean putting it all in a SELECT with appropriate Joins?
You might need a little extra on you dct definition.
This is my standard for Postgres tables:
/BUSYHANDLING=2 /ISOLATIONLEVEL=2 /JOINTYPE='ODBC 3.0' /NESTING=TRUE
Note there is also a Windows ODBC Join limitation of 2 or 3 or something. So more complex stuff it’s better to put into a server side view
Carl Barnes: Edit to add links to help for above parameters.
https://clarion.help/doku.php?id=busyhandling.htm
https://clarion.help/doku.php?id=isolationlevel.htm
https://clarion.help/doku.php?id=jointype.htm
https://clarion.help/doku.php?id=nesting_1.htm
/JoinType='ODBC 3.0' is not in help, but it does say
When using ODBC, the ODBC 3.0 standard does support multiple joins, so ODBC 3.0 compliant drivers should not require this switch.