I really hope someone would help me. I had this query:

"Select distinct DVD.DVDid,Rent_ Detail.RentNo,T itle,Num_of_DVD ,(getdate()-RentDate)+1 As RentPeriod,(CAS E WHEN RentPeriod>5 THEN (RentPeriod-5)*500 ELSE RentPeriod*0 END) As Fine From Member,Rental,D VD,Rent_Detail Where DVD.DVDid=Rent_ Detail.DVDid And Rental.RentNo=R ent_Detail.Rent No And Member.MemberID =Rental.MemberI D And Member.MemberID ='" & ComboBox1.Text &...