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
- 5115 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
Is it possible for a stored procedure to call itself or recursive stored procedure?
Can sql servers link to other servers?
What is the difference between delete and truncate statements?
What are Row versions of DataRow?
How many columns can exist together per table?
What is the log shipping?
Which sql server is best?
What is coalesce in sql server?
How can you list all the columns in a database?
What happens if the update subquery returns no rows in ms sql server?
Explain go command in sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How do you delete duplicate rows in sql server?
What is the difference between Stored Procedures and triggers?
