fULL OUTER JOIN IN T-SQL

• discover.sql

  Mr or Mrs. 500

  Points: 542

  More actions

  May 28, 2009 at 2:51 pm

  #155757

  Hi,

  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.RecipeTitle

  FROM Recipe_Classes, Recipes

  WHERE Recipe_Classes.RecipeClassID *=*

  Recipes.RecipeClassID

  Please suggest an alternative.

  Thanks

• rjv_rnjn

  Hall of Fame

  Points: 3023

  More actions

  May 28, 2009 at 2:57 pm

  #1001787

  How about

  SELECT Recipe_Classes.RecipeClassDescription,

  Recipes.RecipeTitle

  FROM Recipe_Classes full outer join Recipes on Recipe_Classes.RecipeClassID = Recipes.RecipeClassID