From: Adam Flinton 

Robert Comer wrote:
> Is there a way to make the following SQL statement single level?
>
> SELECT      WorkOrder.WRKNO, WorkOrder.RELNO, CombOrder.CO_ID,
> CombOrder.LOTID, SFC_Colors.COLOR,
>                    SFC_Colors.COLOR_ID,
>                    LISTCOL = (CONVERT(char(6), WorkOrder.WRKNO) + '  ' +
> CombOrder.LOTID + '  ' + SFC_Colors.COLOR)
> FROM         WorkOrder INNER JOIN CombOrder ON WorkOrder.WO_ID =
> CombOrder.WO_ID LEFT OUTER JOIN
>                        SFC_Colors ON CombOrder.COLOR_ID =
> SFC_Colors.COLOR_ID
> WHERE      (WorkOrder.ACTIVE = 1 AND CombOrder.ACTIVE = 1)
> ORDER BY WorkOrder.WRKNO, CombOrder.LOTID
>
> It's giving me a headache just thinking about it.
>
> The reason I want to go single level is that a program I have is trying to
> open a cursor on the above procedure and any SQL server ODBC driver in the
> last 6 years throws an error that says you can't open a cursor on a SP that
> has more than 1 select.
>
> Thanks,
>
> - Bob Comer
>
>

How about an intermediate view?

Adam

--- BBBS/NT v4.01 Flag-5