----- Original Message ----- From: "JS" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 19, 2003 1:42 PM Subject: OT: SQL Help
> 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4