SQL query works for Access but not mySQL

[optobionics]

*I'm using the Database Connectivity VIs* Can anyone give me a clue as to why the following query works with an MS Access File DSN but not a mySQL File DSN:
SELECT * FROM (SELECT * FROM WP100598 WHERE SerialNum LIKE '311022-05%' OR SerialNum LIKE '311022-07%') WHERE UTCTime > 1090882800 AND UTCTime < 1092870000 ORDER BY SerialNum desc
Thank you, your help is much appreciated

[Wiebe@CARYA]

Hi,

I don't think MySQL supports nested queries.

Regards,

Wiebe.


"optobionics" wrote in message
news:5065000000080000007EEC0000-1079395200000@exchange.ni.com...
> *I'm using the Database Connectivity VIs* Can anyone give me a clue
> as to why the following query works with an MS Access File DSN but not
> a mySQL File DSN:
> SELECT * FROM (SELECT * FROM WP100598 WHERE SerialNum LIKE
> '311022-05%' OR SerialNum LIKE '311022-07%') WHERE UTCTime >
> 1090882800 AND UTCTime < 1092870000 ORDER BY SerialNum desc
> Thank you, your help is much appreciated

[KileenC]

Hi,

Wiebe is correct. If you are using a MySQL version prior to 4.1, it does not support nested queries (subqueries).


Refer to this MySQL Developer Zone article for alternative workarounds.

Thanks and good luck!

Kileen C.