I am trying to run this query .....<BR><BR>sqltemp= "SHAPE {SELECT * FROM gabriel2002.product}" & _<BR> "APPEND ({SELECT * FROM gabriel2002.pdct_cat} AS pdct_cat" & _<BR> "RELATE product.productID TO pdct_cat.productID)"<BR><BR>and getting this error...<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e14&#039; <BR><BR>[Microsoft][ODBC SQL Server Driver]Syntax error or access violation <BR><BR>Under the gabriel2002 database I have 2 tables named product and pdct_cat (catalog table). I want to list all the items in my product list. A product can be in multiple catalogs, and I dont want to list the product multiple times.<BR><BR>Once this query is working, I will need to know how to add more TABLES in the same query. Such as Material table, Category Table.<BR>