ubject: Re: Subquery question
In the last episode (May 25), Bartis, Robert M (Bob) said:
> 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 'SELE
In the last episode (May 25), Bartis, Robert M (Bob) said:
> 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 (((
--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 t
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_PlanI
Hello.
MySQL doesn't support sub-queries (yet). See the following page for
more information and also for hints how to work without sub-queries:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
I never used full text search before, so I might miss something, but a
starting point for your qu
