Duplicating mysql information on SUM ...
View Single Post
05-26-2011, 05:34 PM
Join Date: Nov 2007
Sounds like a one-to-many relationship so you would need to do a left or right join. Inner join is used for a one-to-one relationship.
If you want to do SUM and other functions like that then you'll need a group by.
I agree with Tony. Name your columns something useful so that in the future it won't take a manual to figure out what data is in each column.
View Public Profile
Send a private message to wGEric
Visit wGEric's homepage!
Find More Posts by wGEric