I have a polygon featureclass and wish to join several tables to this FC in a model, producing a single layer with all tables. What is the best and most efficient way to go about this? Any ideas?
Use the Add Join tool under Data Management Tools > Joins as many times as you need to perform the join, then use the Feature Class to Feature Class tool under Conversion Tools > To Geodatabase, (you can save it as a shapefile or feature class depending on the location), to create a layer that permanently contains those additional fields. You'll probably have to use the Make Feature Layer tool if you're bringing in a shapefile or feature class as the input Layer Name or Table View.
