subquerys

2004-01-29 Thread Rodolphe Toots
hi all! i have a question regardin subselects or subqueries in the SELECT statement i searched the manual yesterday but did not find any answer to this in my SELECT statement i would like to do a subselect like this SELECT t1.field1, t1.field2, (SELECT count(t2.field1) FROM table2 t2 WHERE t2.f

re: subquerys?

2002-11-01 Thread Victoria Reznichenko
Victoria, Friday, November 01, 2002, 2:20:48 AM, you wrote: VM> I'm migrating my access db's to mysql but some querys in Access need sub VM> querys. VM> I know that is n't possible with mysql but maybe with the beta VM> distribution I could do it. VM> can some body helpme, maybe there are other wa

subquerys?

2002-10-31 Thread Victoria Meza
Hi! mysql experts, I'm migrating my access db's to mysql but some querys in Access need sub querys. I know that is n't possible with mysql but maybe with the beta distribution I could do it. can some body helpme, maybe there are other way to do it. thanks, Victoria -