Kirk writes "I probably designed this bad.. but It seemed logical at the time.. I have a 'VEHICLE' and 'COLORS' table and in the vehicles table, I have two FK, ICOLOR and ECOLOR they both reference the 'COLORS' table.. What I did was list the COLORS table twice in my View's FROM clause; I just gave them a different Alias.. this is done in two places, again w/ my ADMIN table.Well, I need to make this query run a lot faster, and removing those two 'extra' nested loops sound like it may help .. I'm not sure if I am approaching this correctly, If you guys could give me some direction that would be great, thanks!.. I have included my SQL Script (SQL 2k, Win2k)CREATE VIEW dbo.VIEW_ACTIVE_VEHICLESASSELECT TOP 100 PERCENT V.*, P.DEALER_PRICE_NUM AS DEALER_PRICE, P.INVENTORY_PRICE_NUM AS INVENTORY_PRICE, P.SALE_PRICE_NUM AS SALE_PRICE, P.SOLD_PRICE_NUM AS SOLD_PRICE, A.FNAME_TXT AS A_FNAME, A.LNAME_TXT AS A_LNAME, M.FNAME_TXT AS M_FNAME, M.LNAME_TXT AS M_LNAME, MK.DESCRIPTION_TXT AS MAKE, ML.DESCRIPTION_TXT AS MODEL, IC.DESCRIPTION_TXT AS ICOLOR, EC.DESCRIPTION_TXT AS ECOLOR, I.IMAGE1_ID AS IMAGE1_ID, I.IMAGE2_ID AS IMAGE2_ID, I.IMAGE3_ID AS IMAGE3_ID, I.IMAGE4_ID AS IMAGE4_IDFROM dbo.VEHICLE V INNER JOIN dbo.ADMIN A ON V.ADDED_BY_ID = A.ID INNER JOIN dbo.PRICE P ON V.ID = P.V_ID INNER JOIN dbo.MODEL ML ON V.MODEL_ID = ML.ID INNER JOIN dbo.MAKE MK ON V.MAKE_ID = MK.ID INNER JOIN dbo.COLOR IC ON V.ICOLOR_ID = IC.ID INNER JOIN dbo.COLOR EC ON V.ECOLOR_ID = EC.ID FULL OUTER JOIN dbo.ADMIN M ON V.MODIFIED_BY_ID = M.ID FULL OUTER JOIN dbo.IMAGES I ON I.V_ID = V.IDWHERE (V.ACTIVE_IND = 1)
"
SQL ONE to MANY Relationship problem. 
Posted - 2001-10-25 : 10:59:04