>>How would I be able to do this in Crystal Reports?

I usually write the query in VFP and get it working the way I want it.
Once it's working well, you can copy and paste it into the "command" of the data section in CR exactly as you wrote in VFP
.