Make Query Table error

Question

Hello,

I have made a very extensive model in ModelBuilder that keeps getting a 999999 error when trying to run a "Make Query Table" tool.  The message dialogue says it has trouble processing a certain, below is the python script of where the error occurs:# Process: Make Query Table...
gp.MakeQueryTable_management("'W:\JointDepartments\Tyler\Model_Test\New Personal Geodatabase.mdb\PropMast'", QueryTable, "USE_KEY_FIELDS", "PropMast.OBJECTID", "PropMast.parcel_code PropMast.parcel_code;PropMast.property_use_code 
...
...
...
PropMast._bedroom_units;PropMast._bedroom_units_1 PropMast._bedroom_units_1;PropMast._or_more_units

I am not sure why this field is causing the error.

Below is the error message:

Start Time: Mon Jul 25 16:49:01 2011
ERROR 999999: Error executing function.
Syntax error in query expression 'PropMast._bedroom_units'.
Failed to execute (Make Query Table).
End Time: Mon Jul 25 16:49:01 2011 (Elapsed Time: 0.00 seconds)

Any help is appreciated!

ChrisSnyder · Answer

If it helps, here is a code snipit. Sorry I know it's pretty cryptic. If you only have a single input table, then the MakeFeatureLayer (or makeTableView) tool would be most appropriate. The added complexity of MakeQueryTable is only "worth it" if you are relating/joining multiple tables. The code below joins two tables to an input FC table and then outputs a feature layer that is the spatial result of the tabular queries.queryExp = "question_1_fma_summary.RMU_ID = rmu_polyid.RMU_ID AND rmu_polyid.RMU_POLYID = rmus_we_care_about.RMU_POLYID AND\
rmus_we_care_about.MM_POL_LBL = 'marginal' AND (\
(rmus_we_care_about.HCPUNIT_NM in ('S-COAST','COLUMBIA') AND question_1_fma_summary.COMPSOLD_DATE >= 20000101) OR\
(rmus_we_care_about.HCPUNIT_NM = 'STRAITS' AND question_1_fma_summary.COMPSOLD_DATE >= 20010501) OR\
(rmus_we_care_about.HCPUNIT_NM = 'OESF' AND question_1_fma_summary.COMPSOLD_DATE >= 20020501) OR\
(rmus_we_care_about.HCPUNIT_NM = 'N-PUGET' AND question_1_fma_summary.COMPSOLD_DATE >= 20011101))"
gp.MakeQueryTable_management(question1FmaSummaryTbl + ";" + rmuPolyIdTbl + ";" + rmusWeCareAboutFC, featureLayerFL, "ADD_VIRTUAL_KEY_FIELD", "", "", queryExp)

ChristopherBlinn1 · Answer

When I create the Query Table, the next step in the model is to select records based on their attribute information.  When the model reaches this step it displays an error and states that there are too few selections, meaning it cannot make a selection.  However, when I make a feature layer it does work.

ChrisSnyder · Answer

Not sure what the problem was, but MakeQueryTable is more suited to complex queries involving multiple tables.