Dan Russell
Member since Dec 11, 2008
- Profile: /members/340-dan-russell.htm
- URL: http://www.ctdlc.org
- Comments: 1
Recent Blog Comments By Dan Russell
-
I Just Can't Understand Object Oriented Programming (OOP) And Join Tables
Posted on Aug 17, 2007 at 9:03 AM
I agree with not being able to wrap your head around JOINs. That why I always use implicit JOINs like this: SELECT p.id p.name FROM practice p, pratice_practice_jn ppjn WHERE p.id = ppjn.child_id AND ppjn.parent_id = <cfqueryparam .... /> ORDER BY ppjn.sort ASC, p.name ASC Same r... read more »