create query table doesn't work in a model

2529
12
09-07-2016 12:11 AM
AntoniaCreese
New Contributor II

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.

Tags (2)
0 Kudos
12 Replies
AntoniaCreese
New Contributor II

no not running table to table tool. The table is exported from database.

0 Kudos
WesMiller
Regular Contributor III

That bug has been around a long while

GarretDuffy
Occasional Contributor

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.

0 Kudos