dlacloche
08-13-2008, 03:51 PM
I've created an online survey that uses 4 forms over 4 web pages to input the data. Each form puts the data into a different table in the database. Each form has a hidden field that inputs the user's firstName and lastName [like: TomJones] that comes from a cookie that was created on a presurvey page.
So that's the unique field that ties all the user's data together.
Question: All 4 tables have a column called cookieInfo [where the TomJones would appear]. How do I join rows [create a record set] from the tables based on matching data in the cookieInfo field?
I'd like to display all answers from a particular user from across the 4 tables.
And here's the bonus question: Is there a way to display % with SQL? Like, 14% of all users who answered a food question, said that pizza is there favorite food.
Any help would be appriciated!!
So that's the unique field that ties all the user's data together.
Question: All 4 tables have a column called cookieInfo [where the TomJones would appear]. How do I join rows [create a record set] from the tables based on matching data in the cookieInfo field?
I'd like to display all answers from a particular user from across the 4 tables.
And here's the bonus question: Is there a way to display % with SQL? Like, 14% of all users who answered a food question, said that pizza is there favorite food.
Any help would be appriciated!!