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

[william humphrey]

strike that -- missing comma.

SELECT s_voyages_date 'sailed', s_masters_name 'Capt', s_ships_fullname,
discharge.s_kcodes_harborname 'discharge',
laden.s_kcodes_harborname 'laden'
FROM shadow_voyages
join shadow_ships on shipname
join shadow_masters on mastername
join shadow_kcodes as discharge on lastport
join shadow_kcodes as laden on portoflading
where s_voyages_voyagenumber = 'SS504'


this works except after a few seconds you get an error


like this



 10:42:18 Query time: 0.003 sec

 10:42:20 Kernel error: 0x51500.

On 11/14/08, william humphrey <shoreagent at gmail.com> wrote:
>
> I'm glad I asked. I've been using the wrong syntax. I will try again now
> too.




-- 
http://www.bluewatermaritime.com