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
- 5213 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 boxing and unboxing concept in .net?
Explain what are commit and rollback in sql?
How to rebuild all indexes on a single table?
What is row_number () and partition by in sql server?
How do we know if any query is retrieving a large amount of data or very little data?
What is transact-sql language?
Define candidate key, alternate key, and composite key.
What is the process of indexing?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Why should one not prefix user stored procedures with ‘sp_’?
How do I setup a local sql server database?
What are user defined functions in ms sql server?
What are the steps to process a single select statement?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are character string data types in ms sql server?
