select a1, a2, a3
		from table1 as t1
		inner join table2 as t2 on t1.t2id=t2.t2id
		inner join 
					(
						select ID from table3 as t3 
						group by id
					) 
					as v1 on v1.id = t1.id