Help on query

From: Ahmadsyah Algozhi Nugroho <aan_at_nwa.iao.co.id>
Date: Mon, 21 May 2001 23:55:09 -0700
Message-ID: <F001.0030A351.20010522000027@fatcity.com>

Dear gurus,

I have a table :
Tabel Exam
STD_NO SUBJECT POINT
====== ======= =====

001    CHEM     A
001    PHYSIC   A
001    BIOLOGY  A


002    CHEM     A

002    PHYSIC   B
002    BIOLOGY  A

003    CHEM     A
003    PHYSIC   A
003    BIOLOGY  B

What is the SQL query to retrieve STD_NO which have CHEM = A and PHYSIC = A?

The output should be :
STD_NO

---

001
003

TIA, Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
INDONESIA
phone : +62 (31) 8708456 ext.113
visit [ORAID!] http://oraid.iwarp.com Received on Tue May 22 2001 - 01:55:09 CDT