Help with SQL queries

Discussion in 'OT Technology' started by KriZZeaM, Dec 16, 2004.

  1. KriZZeaM

    KriZZeaM New Member

    Joined:
    Jul 18, 2002
    Messages:
    8,336
    Likes Received:
    0
    Location:
    Nashville
    i only need to write 4. and they seem simple enough, i have just overloaded my brain these past couple weeks, and cannot figure out how to write a query for the following 3:

    1. write a queriy to list all videos, its category description, the description of each format available, cost of each title

    2. list the first name, last name, date due, title for each unreturned video

    3. write a statement that inserts data into each table.



    any kind of help, examples, or suggestions, will be soo helpful. i cant think straight anymore.
     
  2. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    uhhhh, it would help if you would provide the table structure first of all. This better not be homework :squint:
     
  3. KriZZeaM

    KriZZeaM New Member

    Joined:
    Jul 18, 2002
    Messages:
    8,336
    Likes Received:
    0
    Location:
    Nashville
    if you could just tell me how to pull from multiple tables (not associated by primary key) in one query
     
  4. KriZZeaM

    KriZZeaM New Member

    Joined:
    Jul 18, 2002
    Messages:
    8,336
    Likes Received:
    0
    Location:
    Nashville
  5. KriZZeaM

    KriZZeaM New Member

    Joined:
    Jul 18, 2002
    Messages:
    8,336
    Likes Received:
    0
    Location:
    Nashville
    select title, category_desc, format_desc, cost
    from video, category, format, video_format

    this lists all, but will that list the correct information, such as the right description for the video, or the right format available for each video, or the right cost of each video?? if not how would i specify that.
     
  6. KriZZeaM

    KriZZeaM New Member

    Joined:
    Jul 18, 2002
    Messages:
    8,336
    Likes Received:
    0
    Location:
    Nashville
    anyone?
     
  7. IAMwhitey

    IAMwhitey New Member

    Joined:
    Nov 8, 2001
    Messages:
    1,010
    Likes Received:
    0
    Location:
    Pittsburgh, PA
    do your own homework!
     
  8. KriZZeaM

    KriZZeaM New Member

    Joined:
    Jul 18, 2002
    Messages:
    8,336
    Likes Received:
    0
    Location:
    Nashville
    its not homework, i am studying for my final, and this is a problem in the book i wanted to do cuz i think there will be something similar on the exam.
     
  9. IAMwhitey

    IAMwhitey New Member

    Joined:
    Nov 8, 2001
    Messages:
    1,010
    Likes Received:
    0
    Location:
    Pittsburgh, PA
    umm... ok so its a study guide for the test you are going to be having in school.... hmm
     
  10. IAMwhitey

    IAMwhitey New Member

    Joined:
    Nov 8, 2001
    Messages:
    1,010
    Likes Received:
    0
    Location:
    Pittsburgh, PA
    SELECT p.*, pp.price
    FROM parts AS p, parts_prices AS pp
    WHERE p.num = pp.num

    there is a hint for ya!
     
  11. KriZZeaM

    KriZZeaM New Member

    Joined:
    Jul 18, 2002
    Messages:
    8,336
    Likes Received:
    0
    Location:
    Nashville
    yes a study guide, as in NOT FOR GRADE. it is to help me understand the subject matter more thoroughly.
     
  12. IAMwhitey

    IAMwhitey New Member

    Joined:
    Nov 8, 2001
    Messages:
    1,010
    Likes Received:
    0
    Location:
    Pittsburgh, PA
    ease up cuntboner... i gave you help on how to do the problems.. now go and make your study guide
     

Share This Page