SELECT NOTE FROM COUNTREF WHERE C_CODE='#Country#'
SELECT PISCES.ORIG_NAME,
PISCES.TAXON_NAME,
PISCES.AUTHOR,
PISCES.YR,
pisces.cas_spc,
pisces.type_local,
pisces.cas_ref_no
FROM PISCES
WHERE (((PISCES.C_Code)='#country#')) OR (((PISCES.TYPE_LOCAL)='#getnote.note#'))
ORDER BY PISCES.ORIG_NAME, PISCES.TAXON_NAME, PISCES.AUTHOR, PISCES.YR;
order by PISCES.AUTHOR
order by PISCES.YR
order by PISCES.Type_local
Information by Country - Search Result