select A1.G3E_FID as CAB_FID, A2.G3E_FID as BUS_FID
from [NHGIS_Validation].[dbo].[B_HV_CAB_LN_1_FULLS] A1,
[NHGIS_Validation].[dbo].[B_HV_CONN_S] C1,
[NHGIS_Validation].[dbo].[B_HV_BUS_LN_FULLS] A2,
[NHGIS_Validation].[dbo].[B_HV_CONN_S] C2
where A1.G3E_FID = C1.G3E_FID
AND A2.G3E_FID = C2.G3E_FID
AND (C2.NODE1_ID IN (C1.NODE1_ID,C1.NODE2_ID) OR
C2.NODE2_ID IN (C1.NODE1_ID,C1.NODE2_ID))
请将上面的转成Lam表达,小弟真的不会啊