[AccessD] Invalid operation on query combining 2 queries

The following query generates an invalid operation error message when
executed. Each of the source queries run fine and extracts data from the
same tables. Any thoughts appreciated.

SELECT [qry SAP Puckett Gas Production].ACTVDATE, [qry SAP Puckett Gas
Production].Gas, [qry SAP Puckett Gas Production].[NWI Gas], [qry SAP
Warwink Gas Production].Gas, [qry SAP Warwink Gas Production].[NWI Gas]
FROM [qry SAP Puckett Gas Production] 
INNER JOIN [qry SAP Warwink Gas Production] ON [qry SAP Puckett Gas
Production].ACTVDATE = [qry SAP Warwink Gas Production].ACTVDATE;

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced. 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030403/838388b5/attachment.html>