How to use Access query in SQL statement.
For example
SELECT * FROM MarketCampaignCoOpCredit
in this statement MarketCampaignCoOpCredit is Access query and not a table. If used as above, error says invalid FROM clause.

Pl help.