"the specified field could refer to more than one table" error

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

OK...here is my query:
INSERT INTO OutsourceRecording_Baseline ( OrderMasterID, OrderNum,
ApplicationNum, BorrowerLastName, BorrowerFirstName, PropCounty, PropState,
SubOrderNum, CoBorrowerNameUnparsed, PropAddress, PropCity, PropZip,
BorrowerHomePhone, ServicingLoanNum, LoanAmount, LoanPosition, MtgDot, QCD,
Sub, Oth, FedexTracking, OtherDesc )
SELECT qsptOutsourceRecordingWorklistBaseline_FullDataset.OrderMasterID,
qsptOutsourceRecordingWorklistBaseline_FullDataset.OrderNum,
qsptOutsourceRecordingWorklistBaseline_FullDataset.ApplicationNum,
qsptOutsourceRecordingWorklistBaseline_FullDataset.BorrowerLastName,
qsptOutsourceRecordingWorklistBaseline_FullDataset.BorrowerFirstName,
qsptOutsourceRecordingWorklistBaseline_FullDataset.PropCounty,
qsptOutsourceRecordingWorklistBaseline_FullDataset.PropState,
qsptOutsourceRecordingWorklistBaseline_FullDataset.SubOrderNum,
qsptOutsourceRecordingWorklistBaseline_FullDataset.CoBorrowerNameUnparsed,
qsptOutsourceRecordingWorklistBaseline_FullDataset.PropAddress,
qsptOutsourceRecordingWorklistBaseline_FullDataset.PropCity,
qsptOutsourceRecordingWorklistBaseline_FullDataset.PropZip,
qsptOutsourceRecordingWorklistBaseline_FullDataset.BorrowerHomePhone,
qsptOutsourceRecordingWorklistBaseline_FullDataset.ServicingLoanNum,
qsptOutsourceRecordingWorklistBaseline_FullDataset.LoanAmount,
qsptOutsourceRecordingWorklistBaseline_FullDataset.LoanPosition,
qsptOutsourceRecordingWorklistBaseline_FullDataset.MtgDot,
qsptOutsourceRecordingWorklistBaseline_FullDataset.QCD,
qsptOutsourceRecordingWorklistBaseline_FullDataset.Sub,
qsptOutsourceRecordingWorklistBaseline_FullDataset.Oth,
qsptOutsourceRecordingWorklistBaseline_FullDataset.FedexTracking,
qsptOutsourceRecordingWorklistBaseline_FullDataset.OtherDesc
FROM qsptOutsourceRecordingWorklistBaseline_FullDataset;


It works just great...until I try to add ", ModifyUser" and ",
qsptOutsourceRecordingWorklistBaseline_FullDataset.ModifyUser" in the
appropriate places.

When I do, it returns a "the specified field could refer to more than one
table" error.

Can't figure out why to save my life. Can anybody help? Thnaks.
 
Usually, anytime you get that error, it is telling you that it could pull the
data you ask for from more than one table. Do you have the data you are
needing duplicated in another table? If so, you can specify the table and the
field.
 
Back
Top