Apologize for not including the error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT plantriggers.ID FROM plantriggers WHERE (((plantrigger
I'm running MySQL 4.0.2-standard -----Original Message----- From: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 25, 2005 6:29 PM To: 'mysql' Subject: Subquery question I have a problem where I need to use a subquery in combination with a Left Join. The SQL statement below works fine until I introduce the subquery portion. Specifically, WHERE testplans.plantriggers_ID_FK IN (SELECT plantriggers.ID FROM plantriggers WHERE (((plantriggers.testplan_intro_PlanID_FK)=1))) Can someone point out where the error is. I double checked the column name/tables names in the above portion and as I said the main body worked prior to introduction of the subquery. I've also tried replacing the IN operand with an = with no luck. Full SQL statement: SELECT testplans.SubTestCaseKey, testcase_root.ID, testplans.testcasesuffix_name_FK, testcase_root.TestID, testcase_root.TestDesc, testplans.FSAGA, testplans.Priority, testplans.tester_list_Name_FK FROM testcase_root LEFT JOIN testplans ON testcase_root.ID = testplans.testcase_root_ID_FK WHERE testplans.plantriggers_ID_FK IN (SELECT plantriggers.ID FROM plantriggers WHERE (((plantriggers.testplan_intro_PlanID_FK)=1))) ORDER BY testcase_root.TestID; Robert M. Bartis Lucent Technologies, Inc Tel: +1 732 949 4565 Mail: <[EMAIL PROTECTED]> Pgr: <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
