mungkin data yang 'terlihat' tidak sama dengan yang 'tersimpan'. coba pakai trim untuk setiap expresi string (misal: where trim(periode)='32008')
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Maya Agnelia Sent: Friday, March 28, 2008 10:22 AM To: [email protected] Subject: [belajar-access] tanya mslh operator AND dear friends, ada pertanyaan nih spt ini, SELECT nobill,hrgkwh,hrgm3,totalkwh,totalm3,totaltagihan FROM kwh WHERE (sudahinvoice = 0) AND (kode='T01') AND (periode='32008') AND (lantai = '5') dari sintak diatas koq datanya nggak ketarik ya? padahal stlh aku liat di databasenya ada 1 record apa krn terlalu bnyk operator AND nya ya? tolong solusinya donk friend, makasih ya atas bantuanya databasenya sql server 2000 maya __________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. <http://tools.search.yahoo.com/newsearch/category.php?category=shopping> search.yahoo.com/newsearch/category.php?category=shopping
