Hi Rich,
Seems stupid to me. :-), just joking.
The Junk table doesn't have to be permanent, just around whenever you requery. If your view is controlled via a class, you would know that Junk is open whenever the object is alive.
>>Not a stupid question at all. The consensus seems to be that you need to create a table with integer fields and then UNION it in with the rest of the SELECT.
>
>Ouch. I was afraid of that. I've used a similar trick to get an empty memo field into a SQL SELECT result.
>
>For that to work with a view definition, the table with the integer field would have to exist permanently.
CREATE TABLE Junk (jnk_pk I)
>CREATE SQL VIEW v_AllCustHist AS
> SELECT Table1.Field1,
> Table1.tb1_pk,
> Junk.jnk_pk AS tb2_pk,
> Junk.jnk_pk AS tb3_pk
>UNION SELECT Table2.Field1,
> Junk.jnk_pk AS tb1_pk,
> Table2.tb2_pk,
> Junk.jnk_pk AS tb3_pk
>UNION SELECT Table3.Field1,
> Junk.jnk_pk AS tb1_pk,
> Junk.jnk_pk AS tb2_pk,
> Table3.tb3_pk
>Thanks for the quick response,
Charlie