In Crystal Sql Designer how do you do an embedded query? Do you have to run your first query manually and export it everytime. Or can you just use the first query as your source for your second query? If you can please explain. I'm trying to get around the problem of union on text fields.