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

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.
 
G

Golfinray

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

specified field could refer to more than one table 6
Error: Specified field could refer to more than one table 8
Error: Specified field refers to more than one table 6
specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen 1
Feild could refer to more than one table? 2
Specified field ... could refer to more than one table... 1
specified field error 9
Could refer to more than one table 1

Top