fULL OUTER JOIN IN T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » fULL OUTER JOIN IN T-SQL

fULL OUTER JOIN IN T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

discover.sql

Posted Thursday, May 28, 2009 2:51 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, February 15, 2013 9:08 AM
Points: 30, Visits: 173

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

Post #725474

rjv_rnjn

Posted Thursday, May 28, 2009 2:57 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, February 25, 2013 12:52 PM
Points: 513, Visits: 426

How about

SELECT Recipe_Classes.RecipeClassDescription,
Recipes.RecipeTitle
FROM Recipe_Classes full outer join Recipes on Recipe_Classes.RecipeClassID = Recipes.RecipeClassID

Post #725481

« Prev Topic | Next Topic »

Permissions