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, 2010 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 oldest

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, 2010 at 01:07 PM

David Wimbush gravatar image

David Wimbush
5.1k 29 31 34

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, 2010 at 02:07 PM Michael 4
but Michael, you don't seem to be learning from any of your previous questions
Mar 26, 2010 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, 2010 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, 2010 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, 2010 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:

x375
x76

asked: Mar 26, 2010 at 11:14 AM

Seen: 1150 times

Last Updated: Mar 26, 2010 at 04:16 PM