Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

fULL OUTER JOIN IN T-SQL Expand / Collapse
Author
Message
Posted Thursday, May 28, 2009 2:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Thursday, May 28, 2009 2:57 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 9:37 AM
Points: 513, Visits: 429

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 »

Add to briefcase

Permissions Expand / Collapse