[Yutaka Emura]

Hello Mike,

Thanks for explanation. This is like the JOINT feature of SQL, and I was thinking about this in future versions. Please wait for future versions.

Meanwhile, you can write a macro like this:

doc1 = editor.Documents.Item(1);
doc2 = editor.Documents.Item(2);
editor.NewFile();
doc3 = document;

doc1.Activate();
nLines1 = doc1.GetLines();
doc2.Activate();
nLines2 = doc2.GetLines();
for( y2 = 1; y2 <= nLines2; y2++ ) {
	doc2.Activate();
	s2 = doc2.GetLine( y2 );
	if( s2 == "" ) continue;
	doc1.Activate();
	for( y1 = 1; y1 <= nLines1; y1++ ) {
		s1 = doc1.GetCell( y1, 1, eeCellIncludeNone );
		if( s1 == "" ) continue;
		if( s1 == s2 ) {
			sResult = doc1.GetCell( y1, 2, eeCellIncludeNone );
			doc3.Activate();
			doc3.writeln( s2 + "\t" + sResult );
			break;
		}
	}
}

Thanks!