what i try is
select partc
from #partsc
where VerificationHash in(select VerificationHash
from #VervicationCode);
but i don't need this solution
and i need to generate id for two tables then join by id
so How to do that please ?