[geeks] MySQL complex query.

[Sridhar Ayengar]

Mark Benson wrote:
> Where I'm stuck is I don't know where to specify the select criteria (common
> to both tables) or how to get them to sort by date with 2 different fields. Is
> there maybe a way of copying the different date fields to a new column that is
> common to all records, like 'absolute_date' or somesuch using SELECT AS?

Instead of doing that, why not just use the same column alias for both?

Peace...  Sridhar