SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Trouble with Pubs query
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rbrown0226
Starting Member

4 Posts

Posted - 02/23/2012 :  21:56:54  Show Profile  Reply with Quote
I am having some trouble creating the query below in the Pubs database using SQL Server R2. Any help would be greatly appreciated:

"Select the unique author id as ssn, the lastname and firstname separated by a comma (smith, joe) as Fullname from the authors table joined on the titleauthor table where the royaltyper is less than 50. Order the query by the fullname".

Edited by - rbrown0226 on 02/23/2012 22:01:23

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 02/23/2012 :  22:23:14  Show Profile  Reply with Quote
can you post the used query? the problem statement seems to be a strightforward one

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

rbrown0226
Starting Member

4 Posts

Posted - 02/23/2012 :  22:34:44  Show Profile  Reply with Quote
There is no query.

Edited by - rbrown0226 on 02/23/2012 22:36:49
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17428 Posts

Posted - 02/23/2012 :  22:43:24  Show Profile  Reply with Quote
This seems like homework question. What have you tried so far ? Please post it here so that we can advice

But we will not do any homework here


KH
Time is always against us

Go to Top of Page

rbrown0226
Starting Member

4 Posts

Posted - 02/23/2012 :  22:48:09  Show Profile  Reply with Quote
SELECT authors.au_id as SSN
, authors.au_fname
, au_lname
FROM authors
INNER JOIN titleauthor
ON authors.au_id = titleauthor.au_id
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 02/23/2012 :  22:49:56  Show Profile  Reply with Quote
why? then what have you tried so far?
Dont expect answers to be spoonfed to you
Unless you try yourself, nobody is going to provide you solution

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

rbrown0226
Starting Member

4 Posts

Posted - 02/23/2012 :  22:59:33  Show Profile  Reply with Quote
Well that's a big fuckin' help.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 02/23/2012 :  23:28:01  Show Profile  Reply with Quote
quote:
Originally posted by rbrown0226

Well that's a big fuckin' help.


Just think what you'll gain out of this if somebody is giving you the query.
For your own learning, try to do it yourself, of course we're there to help in case you face any issues
but we clearly need to see an attempt from yourself not just 'give me the answer' kind of threads

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 02/24/2012 :  10:34:37  Show Profile  Reply with Quote
select 'This OP is a dick.' + ',' + ' Is this any help to you?' As FullName
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000