|
Hi,
I'm getting a syntax error when i try to do a
left join in a query of a query.
Query Of Queries syntax error.
Encountered "LEFT" at line 0, column 0. What am i doing wrong?
Gav
<cfquery dbtype="query"
name="all_survey_info">
SELECT qry_survey_question_info.*, qry_survey_mcq_ans_info.* FROM qry_survey_question_info LEFT JOIN qry_survey_mcq_ans_info ON qry_survey_question_info.question_id = qry_survey_mcq_ans_info.question_id </cfquery> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 |
