Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 5256 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
What are the advantages of the mirroring?
How to generate create function script on an existing function?
What Is Rdbms?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Explain transaction server auto commit?
What is the tcp/ip port on which sql server runs?
How to disable a login name in ms sql server?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What is the difference between ‘having’ clause and a ‘where’ clause?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What are the source of constraints?
what are the important architecture components of SSRS?
how to trace the traffic hitting a sql server? : Sql server database administration
What is difference between line feed ( ) and carriage return ( )?
What is a trigger in sql server?
