Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / vrinda

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


Please Help Members By Posting Answers For Below Questions

What is molap and its advantage? : sql server analysis services, ssas

712

Explain features of analysis services?

690

What is an example of a foreign key?

695

How to list all triggers in the database with sys.triggers in ms sql server?

751

What is a raid and what are different types of raid configurations?

846




Why do we backup Active Directory ?

795

What is store procedure? When do you use?

687

Explain what role entity and relationship play in an ER diagram.

789

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

741

Explain linked server in sql?

868

What are system databases into sql server (2005/2008)?

763

How to write character string constants or literals in ms sql server?

759

Explain what are the events recorded in a transaction log?

737

Does sql server 2016 have ssms?

714

How to replace given values with null using nullif()?

724