SQL passthru with included maketable statment?

[perryclisbee via AccessMonster.com]

Morning,

I currently have a maketable query that links to a pass thru query to create
a table. Is there a statement I can add to the passthru query that will make
it create a new table all by itself? Below is my current SQL passthru:

SELECT
CF.CLAIM_FACT,
DD.DATASET_CODE,
DD.DATASET_NAME,
CF.CLAIM_NO,
CF.CLAIM_NO_HDR,
CF.VOIDED,
CF.COVERAGE_TYPE,
FD.FACILITY_CODE,
FD.FACILITY_NAME,

CF.PRIMARY_SPA,
CF.MODALITY_CODE,
PD.PATIENT_CODE,
PD.PATIENT_MPI,
PD.LAST_NAME,
PD.FIRST_NAME,

FC.FINANCIAL_CLASS_MAP AS FC,
CF.CONTRACT,
INS_DIM.PLAN_GROUP,
INS_DIM.INSURANCE_CODE,
INS_DIM.INSURANCE_NAME,
INS_DIM.INSURANCE_PLAN_TYPE,

SER_DIM.SERVICE_DATE,
SER_DIM.SERVICE_MONTH,
POST_DIM.PERIOD,
CF.HEMO_EQ,
CF.GROSS_AMOUNT,
CF.NET_AMOUNT,
CF.ADJUSTMENTS,
CF.RECEIPTS,
(CF.NET_AMOUNT - (CF.ADJUSTMENTS + CF.RECEIPTS)) AS
CLAIM_BALANCE,

VC.ADJ_REVENUE


FROM
SPIDER.CLAIM_FACT CF,
SPIDER.DATASET_DIM DD,
SPIDER.FACILITY_DIM FD,
SPIDER.PATIENT_DIM PD,
SPIDER.SERVICE_DATE_DIM SER_DIM,
SPIDER.POSTING_DATE_DIM POST_DIM,
SPIDER.FINANCIAL_CLASS_DIM FC,
SPIDER.INSURANCE_DIM INS_DIM,
SPIDER.V_CLAIM_FACT VC


WHERE
CF.DATASET_DIM = DD.DATASET_DIM AND
CF.FACILITY_DIM = FD.FACILITY_DIM AND
CF.PATIENT_DIM = PD.PATIENT_DIM AND

CF.CLAIM_FACT = VC.CLAIM_FACT AND

CF.SERVICE_DATE_DIM = SER_DIM.SERVICE_DATE_DIM AND
CF.POSTING_DATE_DIM = POST_DIM.POSTING_DATE_DIM AND

CF.FINANCIAL_CLASS_DIM = FC.FINANCIAL_CLASS_DIM AND
CF.INSURANCE_DIM = INS_DIM.INSURANCE_DIM AND

( SER_DIM.SERVICE_MONTH >= '01-SEP-2004' AND SER_DIM.
SERVICE_MONTH <= '30-SEP-2006') AND
( DD.DATASET_CODE IN ('D','G')) AND
( CF.COVERAGE_TYPE = 'P') AND
( CF.PRIMARY_SPA = 'Y') AND
( CF.VOIDED = 'N')





Thanks,

Perry

 

[Lynn Trapp]

Give this a try. I assume you have named your pass through query and that
you are wanting to create a Jet table from it.

Make Table YourTable AS
Select *
From YourPassThroughQuery;