How move data into a temp table from two tables using the innerjoin

[Netcrawlerrr]

Hi there,

I have a tricky one.....(For me that is.)

I am trying to move data into a temp table, but the date comes from 2 tables using the innerjoin method.

Here is the code I have so far:

INSERT INTO TempTable (SELECT Distinct PlakkerData.Lidno, PlakkerData.DepName, LedeData.POBOX, LedeData.STREET, LedeData.CITY, LedeData.ZIP, CAST(PlakkerData.KorrCode AS varchar(2)) AS KorrCode, PlakkerData.KorrDate, CAST(LedeData.AANTAFH AS VARCHAR(2)) AS AANTAFH, LedeData.LIDTIPE, LedeData.TAAL, CAST(DATEADD(year, 21, CONVERT(datetime, PlakkerData.GebDat, 101)) AS varchar(12)) AS gebdat FROM PlakkerData LEFT OUTER JOIN LedeData ON PlakkerData.Lidno = LedeData.LIDNO WHERE (PlakkerData.KorrCode = 89) AND (LedeData.CheckAudit = 0))

[ck9663]

That's a LEFT JOIN... Try replacing LEFT OUTER with INNER.

Happy Coding!!!

~~ CK