SQL help

[william humphrey]

I forgot about the new forum.  Sure.  I dope it's working.

On Mon, Feb 2, 2015 at 5:33 AM, Ruslan Zasukhin
<ruslan_zasukhin at valentina-db.com> wrote:
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina



-- 
http://www.bluewatermaritime.com