Need to know how to create a joined report like my sample and remove duplicate names

westdh
westdh used Ask the Experts™
on
I need to make a report like so I have 3 table, event table, registration Table, Attendee table

I need to join these table and field from the three table and elimate duplicate names.

sample is in the code, please spread the view
(Table 1 event table)					
 Date	        Event Title					
1/28/2010	     Breakfast of Champions 	 	 	 								
(Table 2 &3 Made from the registration table & the Attendee Table)							
Registration	Company	           Company	                Total	Payment	Date              Registered     Attendee
ID	         Name	           Email	                Amount	Status   Registered 	Attendee	      Email
							
48	        CALTROP Corporation  landxxx@xxxTROP.com	25	cmp	1/18/2010	         Kerry Morgan   jmrxxxx@xxxoo.com
56	        Sensible Environ  	  xxxxx@xxxx.com           50	cmp	1/22/2010 	Robert Sutton     xxxx@xxx.com
                                                                                             	Christa Johnson	xxxx@xxx.com
56	        PGAdesign            xxoxe@xxoo.com	         75	cmp	1/25/2010	         Cindy Angers 	xxxx@xxx.com
                                                                                              	Maura Baldwin     xxxv@xxxx.com	                                                                                           Randy Somerday	xxxx@xxx.com
57	        XYZ Company          xyzxyz@xxoo.com	         75	cmp	1/25/2010	         Cindy Angers 	xxxx@xxx.com
                                                                                              	Maura Baldwin 	xxxx@xxx.com
                                                                                             	Randy Somerday	xxxx@xxx.com
58	        Northern Corporation xxndxxx@xxxTROP.com	25	cmp	1/16/2010	         Berry Street 	xxxx@xxxoo.com

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Systems Analyst
Commented:
can you give better view of those tables ? like what fields refer to each other, what fields each table has etc..

also i suggest you to ask the mods to add the sql area to this question

Author

Commented:
Not full yansered

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial