From bustun@havelsan.com.tr Tue, 22 May 2001 01:40:41 -0700
From: =?iso-8859-1?B?QnVy52luINxzdPxuIEv9bP3n?= <bustun@havelsan.com.tr>
Date: Tue, 22 May 2001 01:40:41 -0700
Subject: Re: Help on query
Message-ID: <F001.0030A493.20010522010526@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: Help on query



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@fatcity.com" 
  title=ORACLE-L@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