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) Order By Logbook.DateObserved Desc , Logbook.ObjectID;
-