I know there are some smart SQL people on this list, so I hope someone would be willing to help me with my problem.
I have 2 tables table 1 uid | person_id | amount table 2 table_1_uid | person_id | percentage I need a way to join these tables to get the percentage of each amount due to a person. I'm having difficulty joining the tables properly, when I join them on any of the fields I get more results than I expect. For example: table 1 1234 | 1 | 1000 1234 | 2 | 1000 table 2 1234 | 1 | 60 1234 | 2 | 40 result 1234 | 1 | 600 1234 | 2 | 400 Thanks, JS __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
