MySQL access and joins

[Kralidis,Tom [Burlington]]

Hi,

Using MapServer (compiled --with-mygis) I have a shapefile and a MySQL
table which I'd like to join on a certain field.  I was pointed to the
following page:

http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?JoinDatasources

Will simple MySQL tables work as the join table?  I believe --with-mygis
will work on a non-sppatial DB

Having said this, what is the state of affairs with mygis and MapServer?
Can I use --with-mygis to connect to MySQL tables with point x/y
columns?  We have done so using the unixODBC and OGR's virtual spatial
data option, but I wonder if the mapmygis.c functionality would perform
better?

If anyone has examples of connecting a MySQL table as a x/y field, that
would be great.

Thanks

..Tom