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
Answers were Sorted based on User's Feedback
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 |
What are the traps ? What are the disadvantages of traps?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
what is a filter?
tell me about aggregate awareness in detail?
How to Implement the the Built-in Strategy Script in BO Designer?
WHAT DOES SQL TAB CONTAIN?
what is static filter and dynamic filter
how to solve the incompatible objects and how they are formed actually.
HOW DO YOU SCHEDULE THE REPORTS?
What is the difference between master-detail and Breaks?
I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?