{217} revision 2 modified: 02-17-2007 18:13 gmt |
you can join two tables by matching their entries!! SELECT * FROM `eval` LEFT JOIN (`infoT` ) ON (infoT.file=eval.file AND infoT.chan=eval.chan AND infoT.unit=eval.unit AND infoT.section=eval.section) WHERE infoT.maxinfo/infoshuf > 20 ORDER BY eval.eval DESC |