Mysql does not have a subquery feature.
does anyone have any thoughts on a workarround ? Besides the obsious, of getting all the records of both tables, and then letting vfp do the sql statments on two local cursors. ?
Bob Lee
>hm.. but i only works in VFP, but returns syntax error when I put it in a mysql GUI program.. i though SQL syntax should be a standard.. any suggestion?
>
>thank a lot!!
In the beginning, there was a command prompt, and all was well.