SQLServerCentral / SQL Server 2005 / T-SQL (SS2K5) / fULL OUTER JOIN IN T-SQL / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 06:12:13 GMT20RE: fULL OUTER JOIN IN T-SQLhttp://www.sqlservercentral.com/Forums/Topic725474-338-1.aspxHow about[code]SELECT Recipe_Classes.RecipeClassDescription,Recipes.RecipeTitleFROM Recipe_Classes full outer join Recipes on Recipe_Classes.RecipeClassID = Recipes.RecipeClassID [/code]Thu, 28 May 2009 14:57:23 GMTrjv_rnjnfULL OUTER JOIN IN T-SQLhttp://www.sqlservercentral.com/Forums/Topic725474-338-1.aspxHi,I am attempting to do a full outer join using this query. but SQL Server neither support this nor "JOIN"statement.SELECT Recipe_Classes.RecipeClassDescription,Recipes.RecipeTitleFROM Recipe_Classes, RecipesWHERE Recipe_Classes.RecipeClassID *=*Recipes.RecipeClassID Please suggest an alternative.ThanksThu, 28 May 2009 14:51:43 GMTdiscover.sql