I need to use the create query table tool. When I do it manually it works fine but will NOT work in a model.
I have both table and spatial layer in athe same personal geodatabase. I have tried using different syntax, double quotes, single quotes, square brackets around table and field expression. All deliver empty results and error 1.
no not running table to table tool. The table is exported from database.
That bug has been around a long while
Verifying this is still a bad bug. Make Query Table works joining two tables together outside of Model Builder but once it's replicated within Model Builder, I get ERROR 000152, Invalid Input Data. Any suggestions/workarounds gratefully received.