Full featured industrial strength SQL platforms, support, use of inner and outer joins in the same query. Microsoft access does not support use of inner joins and outer joins in the same query. For analysis, requiring inner and outer joins, Microsoft access uses should:

A - shelve the analysis while waiting for a more powerful query tool

B - sequence queries so that each query has inner or outer joins, but not both

C - explain to the manager that a more powerful query tool should be acquired

D - look for a job position where the employer supports industrial strength SQL