This query works great with local data.

CREATE SQL VIEW "view_order" AS
SELECT order.* FROM view_customer INNER JOIN order ON view_customer.pkey = order.pkey

I cannot do the same in the remote view because it cannot see the other view when the query is launched...


>Can you show me the SQL? Maybe it can help...
>
>Kamal
>