The Eduladder is a community of students, teachers, and programmers just interested to make you pass any exams. So we help you to solve your academic and programming questions fast.
In eduladder you can Ask,Answer,Listen,Earn and Download Questions and Question papers.
Watch related videos of your favorite subject.
Connect with students from different parts of the world.
Apply or Post Jobs, Courses ,Internships and Volunteering opportunity. For FREE
See Our team
Wondering how we keep quality?
Got unsolved questions? Ask Questions

Database-Management-System-10CS54-VTU-unit-4-->View question


Asked On2017-07-06 05:31:00 by:Aparna-Dasgupta

Taged users:


Likes:
Minazmemon147

Dislikes:
Be first to dislike this question
Talk about this  Like  Dislike
View all qusetions
Answers
For example, for the Corporate Librarian to display a list of contributing authors with their long form department name requires data from the REPORT table (author) and data from the DEPARTMENT table (department name). Obtaining the data you need requires the ability to combine two or more tables. This process is commonly referred to as "joining the tables".

Two or more tables can be combined to form a single table by using the join operation. The join operation is based on the premise that there is a logical association between two tables based on a common attribute that links the tables. Therefore, there must be a common column in each table for a join operation to be executed. For example, both the REPORT table and the DEPARTMENT table have the department identification code in common. Thus, they can be joined.

Joining two tables in Texis is accomplished by using a SELECT statement. The general form of the SELECT statement when a join operation is involved is:

     SELECT   column-name1 [,column-name2] ...
     FROM     table-name1, table-name2
     WHERE    table-name1.column-name = table-name2.column-name ;

Answerd on:2017-07-11 Answerd By:Amogh

Likes:
Be first to like this answer

Dislikes:
Be first to dislike this answer
Talk about this  Like  Dislike

You might like this video:Watch more here

Watch more videos from this user Here

Learn how to upload a video and start earning here



Lets together make the web is a better place

We made eduladder by keeping the ideology of building a supermarket of all the educational material available under one roof. We are doing it with the help of individual contributors like you, interns and employees. So the resources you are looking for can be easily available and accessible also with the freedom of remix reuse and reshare our content under the terms of creative commons license with attribution required close.

You can also contribute to our vision of "Helping student to pass any exams" with these.
Answer a question: You can answer the questions not yet answered in eduladder.How to answer a question
Career: Work or do your internship with us.Work with us
Create a video: You can teach anything and everything each video should be less than five minutes should cover the idea less than five min.How to upload a video on eduladder