Trigger not working with Join?

[dpwsmw]

Here is my trigger and it works great, However, I want to join a table called dbo.CustomerAddressBase and grab the accountbase.accountnumber and insert it into the table customeraddress.CFSMASCustNum, can I do this with one trigger? Can you Join 2 tables in a trigger? Below is my trigger, and then I wanted to add the bottom to it, but it doesn't work.

CREATE TRIGGER [mas_trigger] ON [dbo].[AccountBase]
FOR INSERT
AS
insert dbo.AR1_CustomerMaster
(Division, CustomerNumber,CustomerName,TermsCode, SalesPersonCode,
EmailAddress,URLAddress,PhoneNumber,FaxNumber,CreditLimit, ContactCode)

select
Case
when CFPDivision = 2 then '00' when CFPDivision = 3 then '10' when CFPDivision = 4 then '20'
when CFPDivision = 5 then '30' when CFPDivision = 6 then '40' when CFPDivision = 7 then '50'
When CFPDivision = 8 then '60' when CFPDivision = 9 then '70' when CFPDivision = 10 then '80'
when CFPDivision = 11 then '90'
end,
AccountNumber,[Name],
case
when PaymentTermsCode = 5 then '00' when PaymentTermsCode = 6 then '01'
when PaymentTermsCode = 7 then '02' when PaymentTermsCode = 8 then '03'
when PaymentTermsCode = 9 then '04' when PaymentTermsCode = 10 then '10'
when PaymentTermsCode = 11 then '15' when PaymentTermsCode = 12 then '20'
when PaymentTermsCode = 13 then '25' when PaymentTermsCode = 14 then '30'
when PaymentTermsCode = 15 then '98' when PaymentTermsCode = 16 then '99'
end,
CFSMAS200Salesperson,EMailAddress1,WebSiteURL,Telephone1,Fax,CreditLimit,CFSMASContactCode
from inserted

insert dbo.CustomerAddressBase
(CFSMASCustNum)
select
AccountNumber
from inserted
Join dbo.CustomerAddressBase

This is where it is failing.. Any Help?

 

[onoski]

Although am not an expert on this subject matter yet but am sure there is a way it can be done. Try a search on google, as am sure you get some or more info from there on this task.

 

[vongrunt]

Actually there is solid FAQ about joins on this site. See faq183-4785.

I'm not sure what this CFPDivision/PaymentTermsCode int-to-char replacement code actually does... can you explain it a little bit more?

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.