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
- 4490 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
Differentiate between delete and truncate.
What is forward - only cursors / read only cursor?
How to add more data to the testing table in ms sql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is logshipping and its purpose?
What is sql server database?
Can we insert data into view sql server?
Why use identity in sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
Explain trigger classes i.e. Instead of and after trigger?
Mention what are the core components of ssrs?
How to convert a numeric expression from one data type to another?
What are the tables in sql?
What is difference between standardization and normalization?
What are the different types of sub-queries?
