Hi,
I think It gives the right respose for
you:
select a.std_no from exam a ,exam b where
(a.subject='CHEM' and a.POINT='A') and (b.subject='PHYSIC' and
b.POINT='A')and a.std_no=b.std_no;
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Ahmadsyah Algozhi
Nugroho
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L
Sent: Tuesday, May 22, 2001 11:31
AM
Subject: Help on query
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 <FONT
size=2>002 BIOLOGY A
003 CHEM A
003 PHYSIC A <FONT
size=2>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 <FONT
size=2>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!] <A
href="http://oraid.iwarp.com" target=_blank>http://oraid.iwarp.com
Received on Tue May 22 2001 - 03:40:41 CDT
