>Hi.
>
>I am trying to create a memo place holder in a SQL statement.
>
>Example:
>
>Select field1, field2, memo1 from table1
>union
>Select field1, space(1) as field2, space(?) as memo1 from table2
>
>What is the syntax to actually get the place holder for the memo field? I have tried a few things, but I keep getting a union incompatible statement.
>
>Any suggestions?
>
>Thanks in advance.
>
>Jennifer Ebenhoeh
Jennifer --
Create a dummy table with 1 field -- a memo. Add a record.
Then, create a Cartesian with the table, in the query you want to add the memo. (A Cartesian join is a join between two tables without a WHERE clause or a join condition).
With tm as the memo table, and m1 as the memo field:
Select field1, field2, memo1 from table1
union
Select field1, space(1) as field2, tm.m1 as memo1 from table2, tm
Jay