select Publisherid from title where Authorid =(select Authorid from authour

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?

Question Posted / mythili

3 Answers
5121 Views
I also Faced
E-Mail Answers

Answer Posted / mythili

select Publisherid from title where Authorid =(select Authorid from authour where Authourname='Aut3' )

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are four major operators that can be used to combine conditions on a where clause?

989

What is 'write-ahead log' in sql server 2000 ?

993

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

864

What number sorts of privileges are accessible in sql?

983

Tell me about builtinadministrator?

953

How to update a field in SQL after ALTERING a row?

1184

How to create new tables with "create table" statements in ms sql server?

1002

Difference between aggregate functions of sql?

1043

Explain about Views?

1012

What is xml datatype?

1036

What is Sqlpaging in SqlServer 2005 ?

1016

What Are the Main Features of SQL Azure?

115

Why use “nolock” in sql server?

985

What are the differences between left join and inner join in sql server?

1042

Do you know the policy based administration feature of sql server 2008?

910