No exact match was found for 'Havs lax'.
Please wait. Searching for the near match of your input among thousands of data .
This may take a minute or so.SELECT COMNAMES.ComName AS ResultField1, comnames.comname, comnames.stockcode, comnames.nametype, comnames.c_code, comnames.language, comnames.UnicodeText, Species.SpecCode AS ID_Field, Species.Species, COUNTREF.paese, Species.Genus,comnames.autoctr, species.SpecCode FROM COMNAMES, Species, COUNTREF WHERE COMNAMES.SpecCode=Species.SpecCode AND COMNAMES.C_CODE=COUNTREF.C_CODE AND comnames.misspelling = 0 AND ComNames.ComName = "Havs lax" ORDER BY comnames.nametype