I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author?
Answers were Sorted based on User's Feedback
Answer / mythili
select Publisherid from title where Authorid =(select Authorid from authour where Authourname='Aut3' )
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vrinda
SELECT t1.PUBID,t3.AuthorName
FROM Publisher t1 join Title t2
on t1.PUBID = t2.PUBID
join Author t3
on t3.AuthorID = t2.AuthorID.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / saravanan p
select [Publiser ID] from Title where [Author ID] in(select
[Author ID] from Author where [Author Name]='AuthorName')
Is This Answer Correct ? | 2 Yes | 0 No |
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to connect sql server management studio express to sql server 2005 express?
Difference Between varchar and nvarchar datatype?
Which language is supported by sql server?
How to make a remote connection in a database?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What are the types of processing and explain each? : sql server analysis services, ssas
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
What is left outer join in sql server joins?
What are the different types of lock modes in sql server 2000?
What is the difference between dataadapter and datareader?
Please explain go command in sql server?