This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From28/07/1997 03:39:01
Vinod Parwani #010786
United Creations L.L.C.
Ad-Dulayl, Jordan
To  
All


I have 3 tables

name having names of persons
address having addresses of persons
contact having contact nos. of persons

name is parent which is related with address by code & it is also related with contact by code.

Its one parent and 2 childs.

I want simply a report like this :-

name contact1 address1
name contact2 address2

I have one record in name, 2 in contact and 2 in address, the right result should come as 2 records

instead it is giving me four records, contact nos. and address are getting repeated.

This prob. I have already asked here when I was doing this thing through SQL & was not able to get the solution. So, I tried FoxFire and .... Result is same..