all groups > sql server misc > august 2003 >
You're in the

sql server misc

group:

query problem, #temptable


query problem, #temptable u489685058 NO[at]SPAM spawnkill.ip-mobilphone.net
8/21/2003 5:34:34 AM
sql server misc:
studentID,# of exams, # of passGrades, exam, result
Database is designed to return all above but it prints
the exam and result part only if result < 50.

select studentID,# of exams, # of passGrades, exam,
result
from
A, B, C
where C.result < 50

resulted in nothing to return if there are no result <
50.

How to use select,join,etc to solve this problem?.
How about if all is put in #temptable and deal from one
table?. what would be query in this case?.





--
Sent by mail4u9999 from yahoo within area com
This is a spam protected message. Please answer with reference header.
Re: query problem, #temptable Kresimir Radosevic
8/21/2003 8:23:54 AM
[quoted text, click to view]

Use left join. Like

from
A join B on somecondition left join C on somecondition and C.result < 50

Or you can keep the original where clause.

Regards
KR

"mail4u9999@yahoo.com " <u489685058@spawnkill.ip-mobilphone.net> wrote in
message news:l.1061444074.1722076416@[63.127.215.130]...
[quoted text, click to view]

AddThis Social Bookmark Button