SQL help

[Ruslan Zasukhin]

On 2/2/15, 3:16 AM, "william humphrey" <bill at bluewatermaritime.com> wrote:

> I am getting close.
> 
> SELECT d_containers_FullIndicator, d_containers_number,
> i_containers_owner_ref,s_kcodes_islandname,
> MAX(d_containers_billoflading_ref)
> FROM data_containers
> JOIN info_containers ON container_info
> JOIN info_billoflading ON ContainerNumbers
> JOIN shadow_kcodes ON port_discharge
> WHERE i_containers_owner_ref = '15545'
> GROUP BY d_containers_FullIndicator, d_containers_number,
> i_containers_owner_ref,s_kcodes_islandname
> ORDER BY s_kcodes_islandname
> 
> The above works.

Hi William,

Glad to see you have resolve it.

Can I invite you to our new Forum for such discussions? :-)




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]