SELECT BIBLIOGRAFIA.SIGLA_BIB & IIf(SWT_DOC_BIB.RINVIO>"",", " & SWT_DOC_BIB.RINVIO,"") & IIf(SWT_DOC_BIB.RIN_NOTE>"",": " & SWT_DOC_BIB.RIN_NOTE,"") AS SIGLA, SWT_DOC_BIB.ID_BIB, SWT_DOC_BIB.NPRO, SWT_DOC_BIB.ID_DOC
FROM BIBLIOGRAFIA INNER JOIN SWT_DOC_BIB ON BIBLIOGRAFIA.ID_BIB = SWT_DOC_BIB.ID_BIB
ORDER BY SWT_DOC_BIB.NPRO;

dovrei trasportarla in mysql. la & corisponde al Concat?