InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 17:48:02 GMT20http://www.sqlservercentral.com/Forums/Topic1414927-169-1.aspxUse an OR condition in your join statement?Mon, 04 Feb 2013 08:03:16 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1414927-169-1.aspxTable 1A B C D FA1 B1 NULL NULL NULLA2 B2 NULL NULL NULLA3 B3 NULL NULL NULLA4 B4 NULL NULL NULLA5 B5 NULL NULL NULLTable 2Loc NameA1 WhiteA2 BlackA3 RedA4 OrangeA5 BlueB1 GreenB2 YellowB3 GoldB4 RoseB5 SilverSat, 02 Feb 2013 02:45:58 GMTramanathan.raman88