>You should probably qualify the columns in your where clause, and with >table-names of this length, I would definately use aliases. See if >this helps any.
I was going to, but didn't remember right-off how to do so. I've done so now, thanks. >SELECT ecs.*,er.email >FROM empower_local_case_studies ecs, > empower_registration er >WHERE ecs.page = (param 1) AND ecs.project = (param 2) > AND (ecs.local_case_study_id = er.registration_id) >ORDER BY ecs.local_case_study_id ASC > >Does the registration_id really match the local_case_study_id? -- it >looks like you're joining the primary key on both tables... not that >doing that would have to be invalid, but this doesn't seem like the >sort of situation where I would expect that. I thought that this is how I relate the tables. Really, I'm just trying to have the email address from the registration DB as part of the returned information. I was following a tutorial and it said to make sure the primary keys are =. Here's the tutorial I was using: http://www.w3schools.com/sql/sql_join.asp Is this not right? I'm always interested in learning. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
