What are the names of the projects that Supreme Data Corporation has with you and who manages them

Question

CLIENT

CLIENT_1ID  CLIENT_NAME CONTACT_LAST    CONTACT_FIRST   CONTACT_PHONE
1   Cisco Systems   Martin  Andrew  5215557220
2   Supreme Data Corporation    Martinez    Michelle    5205559821
3   Lucid Technologies  Brown   Jack    7155552311
4   Morningstar Bank    Wright  Linda   9215553320
5   Maverick Petroleum  Miller  Tom 4085559822
6   Birchwood Mall  Brenner Nicole  7155550828

PROJECT

P_ID    PROJECT_NAME    CLIENT_ID   MGR_ID  PARENT_P_ID
1   Hardware Support Intranet   2   105  
2   Hardware Support Interface  2   103 1
3   Hardware Support Database   2   102 1
4   Teller Support System   4   105  
5   Internet Advertising    6   105  
6   Network Design  6   104 5
7   Exploration Database    5   102

Answer 1

0

Come on Michael. Do your own homework, please. If you show you're trying but you're stuck, people will be happy to help but you're making no effort that I can see.

answered Mar 26 '10 at 01:07 PM

David Wimbush
4.2k ● 25 ● 28 ● 31

if I knew how to do SQL Queries myself I would be doing them myself, this is my first time hearing about them

Mar 26 '10 at 02:07 PM Michael 4

but Michael, you don't seem to be learning from any of your previous questions

Mar 26 '10 at 02:19 PM Kev Riley ♦♦

Then perhaps ask a more generalized question. I will talk about theory and techniques all day. I will help spot the bug if you try a query and it doesn't work the way it should. I am not inclined to give answers to specific homework questions though.

Mar 26 '10 at 03:13 PM TimothyAWiseman

In that case, Michael, I recommend a book published by Sams called 'Teach Yourself SQL in 10 Minutes'. It's fairly cheap and explains the basics really clearly.

Mar 26 '10 at 03:20 PM David Wimbush

Oh, if we are talking about books look at The Manga Guide to Databases. It is only a primer, but it is a very gentle introduction to the basic concepts and the story they work it into is actually fairly funny.

Mar 26 '10 at 04:34 PM TimothyAWiseman

(comments are locked)

What are the names of the projects that Supreme Data Corporation has with you and who manages them

Follow this question

Related Questions