home *** CD-ROM | disk | FTP | other *** search
- SELECT Logbook.ObjectID, Logbook.ObservationNumber, Logbook.Catalog, Logbook.DateObserved, Logbook.TimeObserved, Logbook.LocationObserved, Logbook.Transparency, Logbook.Seeing, Logbook.EquipmentUsed, Logbook.Rating, Logbook.ShortDescription, Logbook.ObservationText, Logbook.LogType, CCDLog.ImageName, CCDLog.ExposureTime, CCDLog.ExposureMode, CCDLog.Telescope, CCDLog.CCDcamera, CCDLog.FocalDistance, CCDLog.FieldOfView, CCDLog.CoolingRate, CCDLog.DarkFrame, CCDLog.FlatField, CCDLog.PictureRating, CCDLog.Notes FROM (CCDLog RIGHT JOIN Logbook ON CCDLog.ObservationNumber = Logbook.ObservationNumber) where Rating = 'A' Order By Logbook.DateObserved Desc , Logbook.ObjectID;
-