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
- 5263 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 is the difference between for xml raw and for xml auto?
What is spatial and temporal data?
define and explain the differences between clustered and non-clustered indexes.
when would you go for denormalization? : Sql server database administration
What is @@rowcount in sql?
What is logshipping and its purpose?
Difference between report and query parameter.
What is user-defined inline table-valued function?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is purpose of normalization?
What are filegroups in sql server?
What are the differences between stored procedure and the dynamic sql?
What is normalization of database? What are its benefits?
What is shrink log file?
How much is a sql server license?
