On Tue, 11 Apr 2006, Dylan Beaudette wrote:
[...] I am able to select out the soil depth, excluding certain horizons with the following query: select pedon_id, max(bottom) as depth from horizon where name REGEXP '.?C.?| R|.b.?' != 1 group by pedon_id ; a simple result for the above example would be: +---------------------+-------+ | pedon_id | depth | +---------------------+-------+ | SSGG-spring-05-P009 | 145 | +---------------------+-------+ This works well, except for when I would like to join this aggregated information to a new table in a single query. Is it possible to do something like this:
What query did you try, and what error did you get? I assume you would join the tables, and then distinguish ambiguous column names by leading tham with the corresponding table names in the query. I've used MSSQL more than MySQL, but this seems like it should not be a problem.
Yours, Chris _______________________________________________ vox-tech mailing list vox-tech@lists.lugod.org http://lists.lugod.org/mailman/listinfo/vox-tech