SELECT PicturesMain.*, SPECIES.Genus, SPECIES.Species, Species.DepthRangeDeep, Species.DepthRangeShallow
FROM (SPECIES RIGHT JOIN (PicturesMain LEFT JOIN zweb_PictureType ON PicturesMain.PictureType = zweb_PictureType.PictureType) ON SPECIES.SpecCode = PicturesMain.SpecCode) LEFT JOIN COLLABORATORS ON PicturesMain.Entered = COLLABORATORS.Personnel
WHERE (((PicturesMain.PicName)='#picname#'));
Fish at Depth
This species occurs in #xx# depth.
Depth information not available in FishBase.
Depth Viewer AWT developed by Sherman & Line.
Click on depth scale to see color change. Point at fish for flashlight
effect.