Make Query Table problem

[AndreasStelter]

Hi,

I am trying to join three tables from the same FGDB via Make Query table.

Validation in Model Builder shows no errors. If I run my tool from Model Builder the following error messages are displayed:

ERROR 999999: Error executing function.

An expected Field was not found or could not be retrieved properly. [S_LX_Abzugsbefreiungen_Query]

An expected Field was not found or could not be retrieved properly. [OID]

Failed to execute (Make Query Table).

What's wrong? S_LX_Abzugsbefreiungen_Query is the name of the table that should be created.

The error persists even if I remove the SQL query, so the reason cannot be a syntax error in th query.

BTW: I'm using ArcGIS 10.0 SP5.

Thanks for any help

Andreas

[DanPatterson_Retired]

for the benefit of others...what was it?

[AndreasStelter]

I left the model unchanged (so I didn't have to use Make Query Table) and retrieved the information I needed in C# code instead.

[CharalambosMattheou4]

I have the same problem here. Data are stored in the same workspase. Any advice? Is there a step by step tutorial with relevant dataset available?

Thanks

Charalambos

[CharalambosMattheou4]

Solved . " " in sql statement was the problem.

regards

Charalambos

[RichardTruong]

Yulp, remove the " " in the sql statement will resolve the issue.   Thank you.