General information
Category:
Coding, syntax & commands
Hi Naomi,
Finally figured it out. If the select statement has a memo field in it, you can not use the distinct keyword. But the results are still fairly distinct.
Thanks for you help.
Beth
>Ok, try both selects without the first part before UNION. I think for these two select statements they are not needed. Also you may want to try to simplify these selects (or start building them from simplest to complex) until you find the offending piece. Right now it's still hard for me to figure out what the problem may be.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only