Using JOIN for querying

[Greg Luker]

Hi,

Steve Lime said:
> Correct, supported connection types are MYSQL, CSV, POSTGRES with a
default of
> a dbf file. These joins are only useful for presenting the results of a
query and cannot
> be used for mapping- that is you can't filter or classify features based
on a joined
> dataset. OGR does have the ability to that though. In that case OGR does
the joining
> before MapServer even see's the feature.

I want to display info from a MySQL table and info from joined (related)
MySQL tables, which I have done with a join in the OGR <SrcSQL> SELECT
statement, but mode=query only returns the first record and mode=nquery
shows duplicate data, so this JOIN may be what I need, but could someone
help me with the syntax for CONNECTIONTYPE MYSQL? (I also notice that I need
to compile with --with-mysql)

Thanks,
Greg Luker.