Working in Jupyter Notebooks, arcpy -
Have a MakeQueryLayer function working, but it seems to be ignoring the 'Left' part of the join. It runs and creates an output, but is doing a 1-to-1/Inner join, and I need it to return ALL from one feature class, regardless of whether there is a match in the second table.
I have tried:
"Left Join" - no error just a 1-to-1 output.
"Left Outer Join" - same thing
"Outer Join" returns an unknown error and does not run
It sounds like a database issue to me - what is the underlying database? Our systems use MS SQL Server so I usually test the select statements in the SQL Server Management Studio before using then in arcpy functions such as MakeQueryLayer. Can you so something similar to this?