Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 18th, 2004, 05:18 PM
Registered User
 
Join Date: May 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default oracle problem

The question is "Which other lecturers teach on exactly the same set of modules as 'Jan'; no more or less"

Here is my code:

select teach.lecturer_name "Lecturer Name" from teach
where teach.module_code in
(select module_code from teach
where lecturer_name='Jan')
intersect
select lecturer_name from lecturer
where lecturer_name<>'Jan';


The result came out was the lecturers who teach the same modules as Jan, but it could be more or less. it does not really match the question.

Please help... Thanks..!!

 
Old May 28th, 2004, 05:16 AM
Authorized User
 
Join Date: May 2004
Posts: 28
Thanks: 0
Thanked 1 Time in 1 Post
Default

can you provide us with the table structures.

Cheers






Similar Threads
Thread Thread Starter Forum Replies Last Post
oracle log on problem Hafiz Muhammad Mushtaq Oracle 1 October 18th, 2007 08:24 AM
Oracle problem inthepipe555 Oracle 0 September 28th, 2004 11:19 AM
weird Oracle problem! pankaj_daga Oracle 2 July 12th, 2004 09:33 PM
oracle Date Problem haahoou Oracle 0 January 19th, 2004 05:43 AM
Problem with Oracle provider ohanus Classic ASP Databases 0 September 9th, 2003 09:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.