ArcGIS model builder - make query layer with query parameters from generated values

[المشرف العام]

What I want to do:I want to join a realationship table (same database, not in sde) to a sde feature class to distplay only needed features. This has to be done multiple times according to every row (value) of an other table (same database, not in sde too).The first step works, but I have to make a query layer first as it looks like I cant make joins with tables not in the sde. As I dont want to create ~500 query layers(for the joins), I'm trying to use the modelbuilder to create the query layers (and maybe also to make the joins in the future). The figure below shows the model that Ive created so far (at the moment I dont know if this approach would generally work/do its job).

So whats the problem:I want to use the value catid to perform the query in the Make Query Layer (2).How should/could I do that?

If anybody knows a better solution for my problem --> please tell me!

Thanks

Edit: Thanks for the replies!

Here some pseudothings

table a; -- contains some categories table b; -- =m:n relationship table for "a" and "c"feature class c;table d_*; --contains all data from "b" related to a single category (row) of "a"foreach row in a{ create table d_*;}In psql this would be kind of simple, but I need this done on the ArcGIS level as the join of the feature class relates on this.I was also thinking about python, because using a programming language this would also be kind of simple -- but I have no idea about python and I thought i could avoid this scripting thing :-(



أكثر...