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
- 4228 Views
- I also Faced
- E-Mail Answers
Answer Posted / vrinda
SELECT t1.PUBID,t3.AuthorName
FROM Publisher t1 join Title t2
on t1.PUBID = t2.PUBID
join Author t3
on t3.AuthorID = t2.AuthorID.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What do you mean by a Composite primary key?
How many types of functions are there in sql server?
What is the difference between substr and charindex in the sql server?
What is extent? Types of extents?
What does <> symbol mean?
What is the usage of sign function?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is query parameter in ssrs?
How except clause is differs from not in clause?
How to test subquery results with the exists operator?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How to backup SQL Server Reporting Services ?
What is snapshot parameter in ssrs?
What is sql server programming?
