|
brendalisalowe
Constraint Violating Yak Guru
269 Posts |
 Posted - 2004-08-09 : 12:53:26
|
| I need to retreive data from two different tables and insert it into one table. This is the coding I have so far:INSERT INTO tblCapRec (CaseNumber,PartNumber,Status,LastName,FirstName,Others,SSN,OtherSSN,OtherNotes,InGDB,DocsOrdered,DocsHere,AppHere,Suspended,SentToHUD,SentToTSI,SentToCredit,SpanishCase,MailAddress,MailAddress2,MailCity,MailState,MailZipCode,CareOf,HomePhone,WorkPhone,CellPhone,FaxPhone,OtherPhone,SpousePhone,SpouseWork,SpouseCell,SpouseOther,PropAddress,PropCity,PropState,PropZipCode,Updated,MailKey,MailedFirst,FirstRcvd,AppSent,AppSent2,AppSent3,AppSent4,AppSent5,OrderedDocs,AppRcvd,Paid,FirstBillSent,SecondBillSent,FinalBillSent,FeePaid,MortgageAmt,PaidUpFront,EndorseDate,Term,MatureDate,EncumDate,HoldingMor,ServingMor,RcvdFromOld,RcvdFromRegular,RcvdFromRtn,RcvdFrom2s,RcvdText,RefundAmt,RateCharged,AmtPaid,LateFees,Contract,TFC,Application,Docs,Other,Notes)SELECT * FROM tblBack_From_Accurint INNER JOIN tblHUDdata ON tblBack_From_Accurint.acctno = tblHUDdata.CaseNumber What do I put where I have the "*"? Any input would be great! Thanks!Brenda |
|
Join and Insert into 1 table...help!