I am going to try to explain this and I hope it makes sense. <BR><BR>I have a database with several tables. One table contains the model number and description of a system. Another table contains both a model and a description for any products that are related to that system. In both of these tables I am storing only the Model ID# in both tables. I have another table that contains the Model ID# and descriptions. When I do a search I join these tables in my SQL to get the description to display in the results. I have a need to search and display both the system and the related products. Is there a way I can get the description for both in one SQL statement. I only know how to join it to one table and get the description for one but not both without doing another query to the database for the related equipment. Does anyone know if this can be done? A sample SQL would be most appreciated!