if data in Tbl_Auction -------- 1 1 L 2 2 F 3 3 C 4 4 L 5 5 L 6 6 L
data in Tbl_BidPlace ---------------------- 1 4 1 2 2 1 3 4 2 4 4 1 5 3 2 6 2 2 7 4 1 8 1 1 9 1 2 10 5 1 11 6 1 12 2 1
Pro_id, PlacedBid 1 1 4 3 5 1 6 1
select a.Pro_Id,count(BP.Bidplace_id) from TBl_Auction a,Tbl_BidPlace BP where IsAuction='L' and a.Pro_Id=BP.Pro_id and BP.L_id=4 group by a.Pro_Id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)