how get rid of dupes in inner joins

[pandatime]

Help.

I have a join across four tables. It basically "works" except that the number of rows in the result table is 4x the number that should be there (as a result of the joins that I'm apparently not doing correctly).

select d.c1, d.c2, nr3.c3
into myTable
from table1 t1
join table2 t2 on (t1.c1 = t2.c1)
join table2 t3 on (t2.c2 = t3.c2)
join table3 t4 on (t1.c3 = t4.c3)

I just need one result set. Just the intersection of the columns I need in the 4 tables.

I guess I am not thinking of this correctly. Please help

 

[pandatime]

actually nevermind i think the query is basically correct, the underlying data is actually different than what i thought hence the confusion

 

[NastiaMurzin]

select column1, column2 from oldtable1name newtable1name
cross apply dbo.oldtable2name(newtable1name.oldtable2column1name);
go

or

select column1, column2 from oldtable1name newtable1name
outer apply dbo.oldtable2name(newtable1name.oldtable2column1name);
go

would do.