Using 2 cuerys in MySQL

[Anon]

Hi In ms Accsess I can include different query result in my query. Is it possible in MySQL??????? and how?????

Thanx

[[deleted]]

MySQL does not support sub-queries

This doesn't work:
SELECT * FROM table WHERE id = (SELECT id FROM table2);

[Anon]

So now what????
🙁
but thanx...

[[deleted]]

So now you go and look for a different way of doing what you want to do, without using sub-queries. :-)

[Anon]

Ok I in postgre sql is possible to make functions, but could you explain me how can I create some function in My SQL which results I can use Like ms accsess I can use some other query results????
(also readed mysql manual but could'nt understand from it)
its like I must create f

I tried to work with arrays but got stucked in it.

To create and delete tables are also not the best solution...