Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When to use local filter and when to use global filter?

980


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4392


is it possible to export the webi reports to crystal reports?with out using businessview?

2267


Explain what is the difference between slice and dice and cross tab report?

1055


How we drill up week to month?

1046


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1088


What is the functional & architectural differences between business objects and web intelligence reports?

2391


in sap bi we have wad, then why we go for sap bo

3364


Explain about a time when you discovered a more efficient way to do a work task?

1119


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

2143


What are the steps to do to use alerts in bo?

1373


U r project in which stage in implementation?

2498


What is top business?

1046


what are the day to day activities of BO administrator ?

3012


Explain difference between zabo and webi?

1077