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
- 5114 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
Explain boyce and codd normal form(bcnf)?
What do I need to start working with sql studio? : sql server management studio
Explain syntax for dropping triggers?
When I run the sql server 2000 setup, it just hangs. What do I do?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is the boxing and unboxing concept in .net?
What do you understand by mirroring and mention the advantages of the mirroring?
How much is a sql server license?
What is the New in SQL server 2008?
What is the difference between for xml raw and for xml auto?
We need to perform what steps in the following order to work with a cursor?
What is the exact numeric data type in sql?
What is role playing dimension with two examples? : sql server analysis services, ssas
What command is used to create a database in the sql server and how?
Explain about Joins?
