select a.feld1, a.feld2, ... , b.feld1
from myfile a
left join myfile b
on a.key1=b.key1 and a.key2=b.key2 ....