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
- 4231 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
How many replicas are maintained for each sql azure db?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How raid can influence database performance?
What is cdc in sql server?
What happens if the update subquery returns no rows in ms sql server?
In which sql server version report builder introduced?
How do I find the query plan in sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
What does ss stand for sexually?
Explain what is log shipping?
When cursors are useful?
Does the order of columns in update statements matter?
Explain about system stored procedure?
What is 3nf normalization form?
Explain about unique identifier data type in sql server?
