>Hello buddies.
>There is a way to add fields diferents that the table has to a query.?
>I mean I have many remote views with AS-400; then I have the query I make queries from the views in these queries I need add fields that neither the view neither the table has physically.
>
>TIA
select *, " " as field1, 0 as field2
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown