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
5365 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 changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1082

What are recommended options to be used while using db mirroring? : sql server database administration

1228

Give the query of getting last two records from the table in SQL SERVER?

1009

How do I install sql server?

937

How can you control the amount of free space in your index pages?

1101

Give main differences between "Truncate" and "Delete".

1151

How can change procedure in sql server?

1130

Is it possible to call a stored procedure within a stored procedure?

1026

Can I delete event logs?

977

Can sql servers linked to other servers like oracle?

1008

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2824

What command would you use to create an index?

1108

Explain about sql server login?

1137

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1127

Explain the stored procedure?

1096