>>Hi. Sorry this is such a stupid question < g > but I've looked all through VFP help and can't find the answer.
>>
>>How do you designate an integer constant?!
>>(Like ldDate = {} or lyMoney = $0).
>
>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,