SELECT emb_id,nev FROM kiki_eler,kiki_ember WHERE (kiki_eler.emb_id=kiki_ember.emb_id) AND (tip='email')   ( sor)