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?
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
List out different types of normalizations in sql server and explain each of them?
How to get the definition of a stored procedure back?
Do you know spatial data types - geometry and geography in sql server 2008?
What are relationships and mention different types of relationships in the dbms
How to loop through result set objects using mssql_fetch_array()?
Explain sql delete command?
What is a primary key?
What is a livelock?
Can we use pragma autonomous_transaction in trigger?
Will count(column) include columns with null values in its count?
Does full backup break log chain?
What are group functions in query statements in ms sql server?
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain the creation and execution of a user-defined function in the sql server?
Can the query output be sorted by multiple columns in ms sql server?