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.
Printable View
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.
select statement from query does work. Your statement is correct. Check the name of the query. That is the only place where you can make a mistake. Just to make sure go to Access and create a new query and check it.
Iouri Boutchkine
[email protected]