Thanks R937
While your code did not work, due to syntax error It at least showed me that I was heading in the right direction. Most times that is as good as any specific advice.
Through trial and error I came to a working solution,
I WAS SO CLOSE BEFORE
"Select * FROM DHistory,DToday where...