coba yg ini : select a.*, b.* from tableA a left join tableB b on a.code=b.code where b.unit = 'buah'
----- Original Message ----- From: "Michael" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, June 10, 2008 5:28 PM Subject: [Programmer-VB] Tanya Query > dear all, > > Langsung aja ya. Misalnya saya punya 2 table. > TabelA isinya: > Code Name > ----------------- > 1 nama1 > > TableB isinya: > Code Unit > ------------------- > 1 Buah > 1 Lusin > > Query saya: > select a.*, b.* from tableA a > left join tableB b on a.code=b.code > Hasilnya pasti 2 record. > > Pertanyaannya: > Gimana cara querynya agar hasilnya cuma 1 record (maunya cuma pake Unit > Buah). > Thanks > > regards, > > > ------------------------------------ > > Wahana Programmer Groups Links > > > > > > This email was Anti Virus checked by Security Gateway. > http://www.ptjas.co.id >
