Re: combining inner and outer joins
From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 08/23/04
- Next message: fred: "using select into in a stored procedure."
- Previous message: Todd: "combining inner and outer joins"
- In reply to: Todd: "combining inner and outer joins"
- Next in thread: Tom Moreau: "Re: combining inner and outer joins"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Aug 2004 11:19:39 -0400
Todd,
Please post DDL (CREATE TABLE statements), sample data (INSERT statements),
the query that works for you in Sybase, and the output you're looking for.
"Todd" <lordstanleycup@hotmail.com> wrote in message
news:0cfc01c48923$e34dbd80$3a01280a@phx.gbl...
> Hello,
>
> I've recently switched from Sybase to SQL Server, and am
> trying to do a join (that Sybase had no problem with) that
> SQL Server will not allow:
>
> 3 tables:
>
> tables: store store_att attribute
>
> columns: key *----- key
> att_code ----- att_code
> att_desc
>
> I need a query that will return all rows from store, along
> with the att_desc when there is a match. (Store att may
> have no, or many records to match the key). SQL Server
> does not allow this stating the table is an inner member
> of an outer join clause. How do I go about this in SQL
> Server? I've tried to workaround using a view with the
> outer join, and then using a inner join in the query, but
> no luck, same message.
>
> thanks
> Todd
- Next message: fred: "using select into in a stored procedure."
- Previous message: Todd: "combining inner and outer joins"
- In reply to: Todd: "combining inner and outer joins"
- Next in thread: Tom Moreau: "Re: combining inner and outer joins"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
