Anyone know why this code below doesn't work, it ask for a seller parameter,
however the bottom code works just fine.
Code:SELECT countBID.iid FROM ( SELECT iid, seller, startTIME , count(*) as cntBID FROM bid GROUP BY seller, iid, startTIME HAVING count(*) = 1 ) AS countBID
Code:SELECT countBID.seller FROM ( SELECT iid, seller, startTIME , count(*) as cntBID FROM bid GROUP BY seller, iid, startTIME HAVING count(*) = 1 ) AS countBID