Nested SQL queries

[Anon]

Hey everyone,

I am having problems writing a nested sql statement here is what I have (which is not working at all right now)

SELECT sum(incomingDialup) FROM techdata WHERE shiftReportId = (SELECT id FROM shiftreports WHERE month=3)

What am i doing wrong here?

[Anon]

btw, this is mysql

[Anon]

mysql doesn't support sub-selects.

[van__]

true, but MySQL4.1 is touting sub-selects.
Not supposed to be Alpha till the beginning of 2003 though so don't hold your breath.
But nice to know about.

http://www.mysql.org/products/mysql-4.0/index.html

[[deleted]]

MYSQL: 'why do today what you can put off till tomorrow?' 🙂