Consegui executar o JOIN criando uma consulta salva para cada tabela para converter o campo Memorando para Texto e, em seguida, JOIN as consultas . Para dados de teste em [Tabela 1]
ID GUID_Memo Description
-- -------------------------------------- -----------
1 {453EE643-BFE5-4D8B-B9F1-2B66C71E609A} Table1: foo
2 {80BC2B94-7AC2-4956-959B-E8B624F06502} Table1: bar
e [Tabela 2]
ID GUID_Memo Description
-- -------------------------------------- -----------
6 {453EE643-BFE5-4D8B-B9F1-2B66C71E609A} Table2: foo
7 {80BC2B94-7AC2-4956-959B-E8B624F06502} Table2: bar
em que [GUID_Memo] são campos Memo
reais, as consultas salvas [Consulta1]
SELECT Left([GUID_Memo],100) AS GUID_Text, Table1.Description
FROM Table1;
e [Query2]
SELECT Left([GUID_Memo],100) AS GUID_Text, Table2.Description
FROM Table2;
quando unidos
SELECT
Query1.GUID_Text,
Query1.Description AS Description1,
Query2.Description AS Description2
FROM
Query1
INNER JOIN
Query2
ON Query1.GUID_Text = Query2.GUID_Text;
resulta em
GUID_Text Description1 Description2
-------------------------------------- ------------ ------------
{453EE643-BFE5-4D8B-B9F1-2B66C71E609A} Table1: foo Table2: foo
{80BC2B94-7AC2-4956-959B-E8B624F06502} Table1: bar Table2: bar