[ANN] Reports, Reports, Reports // Valentina 4.0b7

[william humphrey]

I found out that you can't use "as" in the query for the reports.

This query


SELECT s_voyages_date as sailed, s_voyages_voyagenumber as voy,
discharge.s_kcodes_harborname as discharge,
laden.s_kcodes_harborname as laden
FROM shadow_voyages
join shadow_kcodes as discharge on lastport
join shadow_kcodes as laden on portoflading
where s_voyages_voyagenumber = 'SS504'


fails


while this query


SELECT s_voyages_date, s_voyages_voyagenumber,
discharge.s_kcodes_harborname,
laden.s_kcodes_harborname
FROM shadow_voyages
join shadow_kcodes as discharge on lastport
join shadow_kcodes as laden on portoflading
where s_voyages_voyagenumber = 'SS504'


works except that you don't get a distinction between the laden port and the
discharge port anymore.


Should I put this in Mantis?  I'm still using reports only on my Intel
Mac...