Daniel, > SELECT sce.filterName, sce.field, sce.camcol, sce.run > FROM Science_Ccd_Exposure AS sce > WHERE (sce.filterName like '%') > AND (sce.field = 536) > AND (sce.camcol like '%') > AND (sce.run = 94); > > I think the sce.filterName like '%' and sce.camcol like '%' clauses > are nearly useless. Yes, but they allow the same query template to be used in a variety of situations, limiting to a specific filter or not. These are machine-generated queries, not human-written ones. -- Kian-Tat Lim, LSST Data Management, [log in to unmask] ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1