I was wondering about combining the results of two different collections and
the best way to approach this. If I have 1 table which consists of 3 fields,
ID, memo1, and memo2, and I want people to be able to independently search
either memo1, or memo2, or both, should I have 2 or 3 collections to do this?
What I've got right now is 2 collections with memo1 or memo2 in the body
attribute and the ID in the custom1 attribute. So I'd like to do this:
select * FROM memo1collection union select * FROM memo2collection ORDER
BY custom1 but it's throwing an error: Query Of Queries runtime error. All
resulting columns of queries in a SELECT statement containing a UNION operator
must have corresponding types. Columns with index number equal '5' have
diffent types (VARCHAR, OTHER). Both memo fields are just access DB memo
fields and the ID field is identical to both collections. Can anyone help me
out on this? Or should I just create a 3rd collection (not optimal for disk
space obviously) that contains both sets. Thanks, Oak