x

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

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
more ▼

asked Mar 26 '10 at 11:14 AM in Default

Michael 4 gravatar image

Michael 4
9 9 9 9

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Mar 26 '10 at 01:07 PM

David Wimbush gravatar image

David Wimbush
4.7k 28 29 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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x362
x74

asked: Mar 26 '10 at 11:14 AM

Seen: 1007 times

Last Updated: Mar 26 '10 at 04:16 PM