Home -> Usenet -> c.d.o.tools -> Simple Question for a Oracle/SQL Guru

Simple Question for a Oracle/SQL Guru

From: Jaswinder Suri <Jaswinder.Suri_at_msdw.com>
Date: Wed, 08 Dec 1999 09:23:48 +0000
Message-ID: <384E23A4.8006F298_at_msdw.com> 





Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit




I am a novice at writing SQL commands to manipulate an Oracle database
and am having difficulty combining the following Select statements that
determine - Which patients


were seen by two Dentist during the months of August and September.



Select 1


Select Appointment.Patient_no, Patient.Patient_no, Appointment.Sv_date
from Appointment, Patient


where Appointment.Patient_no = Patient.Patient_no and

          Appointment.D_name ='Miss Brown' and
          Appointment.Sv_date Between to_date('01-AUG-99') and





to_date('30-SEP-99');



Which returned the following result


[Quoted] Patie     Patie     Sv_Date
-----     -----     ---------




f4221    f4221   24-AUG-99


M1321 M1321 30-SEP-99


And also


Select 2


Select Appointment.Patient_no, Patient.Patient_no, Appointment.Sv_date
from Appointment, Patient


where Appointment.Patient_no = Patient.Patient_no and

          Appointment.D_name ='Mr Hussein' and
          Appointment.Sv_date Between to_date('01-AUG-99') and





to_date('30-SEP-99');



Which returned the following result


Patie     Patie     Sv_Date
-----     -----     ---------
f4221    f4221   21-AUG-99




f4221    f4221   17-SEP-99


f4221    f4221   18-SEP-99



Problem is If i want to determine from the outputs which Patient saw
both Dentist between


the months of August and September i would combine the select statements
above, as follows



1   Select Appointment.Patient_no, Patient.Patient_no,
Appointment.Sv_date


2   from Appointment, Patient


3   where Appointment.Patient_no = Patient.Patient_no and

4             Appointment.D_name ='Mr Hussein' and
5             Appointment.Sv_date Between to_date('01-AUG-99') and
6
[Quoted] to_date('30-SEP-99')                      IN

7          (Select Appointment.Patient_no, Patient.Patient_no,
Appointment.Sv_date
[Quoted] 8          from Appointment, Patient
9          where Appointment.Patient_no = Patient.Patient_no and
10                  Appointment.D_name ='Miss Brown' and
11                  Appointment.Sv_date Between to_date('01-AUG-99') and






to_date('30-SEP-99'));



I keep getting an Error at line 6

           IN
           *




[Quoted] ORA-00933:  SQL command not properly ended



Can anyone  please tell me what i am doing wrong. I just can not see the
mistake.



Thank you for helping,



Bye.



Jas





--------------06EAE59262A2DD5E87C55DDD
[Quoted] [Quoted] Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">


<HTML>




&nbsp;


<BR>I am a novice at writing SQL commands to manipulate an Oracle database


and am having difficulty combining the following Select statements that
determine - Which patients


<BR>were seen by two Dentist during the months of August and September.

<P>Select 1

<BR>Select Appointment.Patient_no, Patient.Patient_no, Appointment.Sv_date

<BR>from Appointment, Patient

<BR>where Appointment.Patient_no = Patient.Patient_no and


<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Appointment.D_name


[Quoted] ='<FONT COLOR="#FF0000">Miss Brown</FONT>' and


<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Appointment.Sv_date


Between to_date('01-AUG-99') and


<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


to_date('30-SEP-99');


<P>Which returned the following result

<P>Patie&nbsp;&nbsp;&nbsp;&nbsp; Patie&nbsp;&nbsp;&nbsp;&nbsp; Sv_Date

<BR>-----&nbsp;&nbsp;&nbsp;&nbsp; -----&nbsp;&nbsp;&nbsp;&nbsp; ---------

<BR>f4221&nbsp;&nbsp;&nbsp; f4221&nbsp;&nbsp; 24-AUG-99

<BR>M1321 M1321 30-SEP-99

<P>And also

<BR>Select 2

<BR>Select Appointment.Patient_no, Patient.Patient_no, Appointment.Sv_date

<BR>from Appointment, Patient

<BR>where Appointment.Patient_no = Patient.Patient_no and


<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Appointment.D_name


[Quoted] ='<FONT COLOR="#FF0000">Mr Hussein</FONT>' and


<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Appointment.Sv_date


Between to_date('01-AUG-99') and


<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


to_date('30-SEP-99');


<P>Which returned the following result

<P>Patie&nbsp;&nbsp;&nbsp;&nbsp; Patie&nbsp;&nbsp;&nbsp;&nbsp; Sv_Date

<BR>-----&nbsp;&nbsp;&nbsp;&nbsp; -----&nbsp;&nbsp;&nbsp;&nbsp; ---------

<BR>f4221&nbsp;&nbsp;&nbsp; f4221&nbsp;&nbsp; 21-AUG-99

<BR>f4221&nbsp;&nbsp;&nbsp; f4221&nbsp;&nbsp; 17-SEP-99

<BR>f4221&nbsp;&nbsp;&nbsp; f4221&nbsp;&nbsp; 18-SEP-99


<P>Problem is If i want to determine from the outputs which Patient saw


both Dentist between


<BR>the months of August and September i would combine the select statements


above, as follows


<P>1&nbsp;&nbsp; Select Appointment.Patient_no, Patient.Patient_no, Appointment.Sv_date

<BR>2&nbsp;&nbsp; from Appointment, Patient
[Quoted] 
<BR>3&nbsp;&nbsp; where Appointment.Patient_no = Patient.Patient_no and


<BR>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


[Quoted] Appointment.D_name ='<FONT COLOR="#FF6666">Mr Hussein</FONT>' and


<BR>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Appointment.Sv_date Between to_date('01-AUG-99') and


<BR>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


to_date('30-SEP-99')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


<FONT COLOR="#FF6666">IN</FONT>


[Quoted] <P>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Select Appointment.Patient_no,


Patient.Patient_no, Appointment.Sv_date


[Quoted] <BR>8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from Appointment,


Patient


[Quoted] <BR>9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where Appointment.Patient_no


= Patient.Patient_no and


<BR>10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


[Quoted] Appointment.D_name ='<FONT COLOR="#FF6666">Miss Brown</FONT>' and


<BR>11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


Appointment.Sv_date Between to_date('01-AUG-99') and


<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


to_date('30-SEP-99'));


<P>I keep getting an Error at line 6

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *

<BR>ORA-00933:&nbsp; SQL command not properly ended


[Quoted] <P>Can anyone&nbsp; please tell me what i am doing wrong. I just can not


see the mistake.


<P>Thank you for helping,

<P>Bye.

<P>Jas

<BR>&nbsp;

<BR>&nbsp;


<BR>&nbsp;</HTML>





--------------06EAE59262A2DD5E87C55DDD--

Received on Wed Dec 08 1999 - 10:23:48 CET












Original text of this message