选择
(selectcount(*) from table2 where table2.table2Seq = table1.table1Seq and table2Yn = true) as count2,(select count(*) from table2 where table2.table2Seq = t
这是我的问题 WHERE (date >= '2012-06-26'AND date < '2012-06-30') AND (Avail > '0')SELECT COUNT(*) as total, toys, date FROM T2
WHERE (date >= '2012-06-26'ANDdate < '2012-06-3