You should be able to join as many tables as you like (just as in a regular query). Just select the column names you need
insert into tblthis (columnone, columntwo, columnthree) select c.dataone, d.datatwo, e.datathree from mycolumns c inner join mycolumnstwo d on (c.my_id = d.my_id) inner join mycolumnsthree e on (c.my_id = e.my_id) where c.typename = 'General' >Oh, so IOW I can only do that for one join table, not more than one? >I have a couple of lookup columns that I'll be inserting... > >Pete > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202213 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54