
April 8th, 2004, 09:28 PM
|
|
Registered User
|
|
Join Date: Apr 2007
Posts: 22,309
Time spent in forums: < 1 sec
Reputation Power: 24
|
|
|
cannot get right result from query
Hi
I am using following query to display the students i havent entered dem o for but it is giving me all the student name but i have entered demo for 2 students.
SELECT DISTINCT ss.student_id,ss.supervisor,ss.examiner from STAFF_STUDENT ss,DEMO d where ss.student_id != d.student_id
[/highlight]
I have tried not like command as well, if i dont use distinct i get 2 row for every student can any one help me please
structure for staff_student table
Code:
CREATE TABLE STAFF_STUDENT (
student_id varchar(20) NOT NULL default '0',
supervisor varchar(60) default NULL,
examiner varchar(60) default NULL,
demo int(1) NOT NULL default '0',
PRIMARY KEY (student_id)
) TYPE=MyISAM;
structure for demo table
Code:
CREATE TABLE `DEMO` (
`Room` char(10) NOT NULL default '',
`Choice` char(3) NOT NULL default '',
`hh` int(2) NOT NULL default '0',
`mm` int(2) NOT NULL default '0',
`student_id` char(15) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`student_id`)
) TYPE=MyISAM;
|