Tow tables is there employee, projects . (many to many) one employee has differ

Tow tables is there employee, projects .
(many to many) one employee has different projects and one
project has different employees . how we can achive the data
from both

Question Posted / vinodkrishnamsetty

2 Answers
5530 Views
Hexaware, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Tow tables is there employee, projects . (many to many) one employee has different projects and one..

Answer / raja mahesh

Here a row in Employee table can have many matching rows in Projects table, and vice versa. You create such a relationship and can retrieve data by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table employee table and projects table.

Is This Answer Correct ?

9 Yes

0 No

Tow tables is there employee, projects . (many to many) one employee has different projects and one..

Answer / praveen

What kind of data(column) they need that not mentioned in
the question.

But, If they want data from both table we can use Join
comments by using primary key and forien key

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Business Objects Interview Questions

what is the difference b/w star and snowflack schema in dataware house?

8 Answers

What is the pragma?

2 Answers

What is meaning of fullpath client in business objects?

1 Answers Atiric Software,

Difference between zabo and webi?