Erica L Ridley <[EMAIL PROTECTED]> wrote:
> I need help with rewriting a sql query. Nested queries that work in MS
> databases apparently do not work in MySQL databases. Here is what I need
> in MS query pseudo code:
>
> SELECT table1.myfield1, table2.myfield2
> FROM table1, table2
> WHERE ta
I need help with rewriting a sql query. Nested queries that work in MS
databases apparently do not work in MySQL databases. Here is what I need
in MS query pseudo code:
SELECT table1.myfield1, table2.myfield2
FROM table1, table2
WHERE table1.key=table2.key AND myfield1="something"
AND myfiel
