SoftwareTipsandTricks Forum

Go Back   SoftwareTipsandTricks Forum > General Forums > Chit Chat
User Name
Password


sql problems!!

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes

  #1  
Old 04-11-2004, 01:22 PM
hassan786 Offline
Junior Member
 
Join Date: Jan 2004
Posts: 11
sql problems!!

i didnt really know which section to post this is, so i thought i'd post it here.
I have an assignment where i have to write sql statements from questions given by the lecturer, i'm really stuck on a couple of Qs:

Database:

Tables:

Team(team_name, competitor_no)

Competitor(competitor_no, competitor_name, team_name)

Quiz(quiz_no, competitor_no, question_no, competitor_answer)

Question_bank(questtion_no, question_text, Correct_answer, section)

This is the question....

"Lost any section where all questions belonging to that section have been used in a quiz."

I must represent the above statement using sql....this is what i have done so far:

Select: section
From: Question_bank
Where: (quiz.Question_no -(minus) question_bank.question_no.......

am i on the right tracks? how can i talk about relating sections to question numbers seeing as though the section is the desired outcome but is not present in the quiz table?

I am really clueless about this one, do u know any good sql sites that might help me with the problem???
Reply With Quote

  #2  
Old 04-11-2004, 01:43 PM
Play_The_0dds's Avatar
Play_The_0dds Offline
Risk it all
 
Join Date: Oct 2003
Posts: 2,231
hate to redirect you to another forum, their maybe several people here who can answer the post. if they dont try posting at the forum link below, you will find they have sections just for this.
http://forums.devshed.com/index.php?
Reply With Quote

  #3  
Old 04-11-2004, 01:59 PM
hassan786 Offline
Junior Member
 
Join Date: Jan 2004
Posts: 11
thnx play_the_odds
Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Abit NF7-S Rev. 2 SATA Problems... Get Smiley figures at bootup.... Trance_Allstar Hardware Problems 3 09-15-2005 05:47 PM
WinXP Repair/Reinstallation problems -- need help Heatmiser Windows XP 1 12-28-2004 12:49 PM
Internet problems + logon problems + ... windowsuser Windows XP 3 10-03-2004 11:55 PM
PRIMARY HARD DRIVE FAILURE-HELP!!/Image dll.Rundll Problems Kitten04 Windows XP 2 05-19-2004 06:44 PM
XP system problems Mhertzler Windows XP 4 04-07-2004 06:10 AM



All times are GMT -5. The time now is 03:11 AM.


Designed by eXtremepixels. Powered by vBulletin Version 3.5.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 2.3.2 © 2005, Crawlability, Inc.