sql don't work

THIS very simple sql, don't work, only show data for first select, but if
delete clausule where in second select, show rows correct of first select
and all rows in second select (for demostrate that 2 select run, but second
where don't work)

SELECT idpedido, montaje, fecha, descripcion, proveedor, valor, factura,
anulado, importereal, importepedido, importeprevisto, nombrepos

FROM Pedido where montaje ='464-M-03'

UNION ALL

SELECT idpedido, montaje, fecha, descripcion, proveedor, valor, factura,
anulado, importereal, importepedido, importeprevisto, nombrepos

FROM d2003.Pedido where montaje ='464-M-03'

On Mon, 2 Feb 2004 14:32:53 +0100, "F. Alvarado" <empresa@neta2.com>
wrote:

>THIS very simple sql, don't work, only show data for first select, but if
>delete clausule where in second select, show rows correct of first select
>and all rows in second select (for demostrate that 2 select run, but second
>where don't work)
>
>SELECT idpedido, montaje, fecha, descripcion, proveedor, valor, factura,
>anulado, importereal, importepedido, importeprevisto, nombrepos
>
>FROM Pedido where montaje ='464-M-03'
>
>UNION ALL
>
>SELECT idpedido, montaje, fecha, descripcion, proveedor, valor, factura,
>anulado, importereal, importepedido, importeprevisto, nombrepos
>
>FROM d2003.Pedido where montaje ='464-M-03'
>

Nexus does not support SQL statement which include tables from more
than one database.

Multi Alias SQL is already on the wishlist.


Regards from Germany

Franz-Leo Chomse [NexusDB Expert]
franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)

do you have any solution or good idea please?.

"Franz-Leo Chomse [NDX]" <franz.leo.chomse@ndx.nexusdb.com> escribió en el
mensaje news:duks1054tkbhrt3qsa39mcmbtp45mls2qj@4ax.com...
> On Mon, 2 Feb 2004 14:32:53 +0100, "F. Alvarado" <empresa@neta2.com>
> wrote:
>
> >THIS very simple sql, don't work, only show data for first select, but if
> >delete clausule where in second select, show rows correct of first select
> >and all rows in second select (for demostrate that 2 select run, but
second
> >where don't work)
> >
> >SELECT idpedido, montaje, fecha, descripcion, proveedor, valor, factura,
> >anulado, importereal, importepedido, importeprevisto, nombrepos
> >
> >FROM Pedido where montaje ='464-M-03'
> >
> >UNION ALL
> >
> >SELECT idpedido, montaje, fecha, descripcion, proveedor, valor, factura,
> >anulado, importereal, importepedido, importeprevisto, nombrepos
> >
> >FROM d2003.Pedido where montaje ='464-M-03'
> >
>
> Nexus does not support SQL statement which include tables from more
> than one database.
>
> Multi Alias SQL is already on the wishlist.
>
>
> Regards from Germany
>
> Franz-Leo Chomse [NexusDB Expert]
> franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)

>do you have any solution or good idea please?.

The only one is to combine the resultset of two TnxQuery instances
into a local table (momory table) on client side.


Regards from Germany

Franz-Leo Chomse [NexusDB Expert]
franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)