select [Publiser ID] from Title where [Author ID] in(select [Author ID] f

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 / saravanan p

3 Answers
5220 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain transaction server isolation?

1005

What is b tree index?

902

What is SQL Azure Federations?

112

What part does database design plays a role in performance of an sql server-based application?

963

Why do we need different type of parameter?

1039

Explain what is the main purpose of having conversation group?

918

How to list all user names in a database?

1038

Explain transaction server auto commit?

1024

What is the ‘fillfactor’?

952

How to read data in a table with "select" statements?

952

What is the sql profiler?

928

How to list all stored procedures in the current database using ms sql server?

1111

What is acid mean in sql server?

1094

What are commonly used odbc functions in php?

1001

What are the indexes in sql server?

1096