SQL help

[william humphrey]

Hi again
I'm trying to do an update with JOIN

UPDATE data_containers
JOIN info_billoflading ON container_info
SET d_containers_FullIndicator = 'FUL'
WHERE i_billoflading_export_fl = TRUE
AND d_containers_FullIndicator = 'EMP'

This works fine in a select statement but I'm having trouble using it
for the UPDATE

On Sun, Jan 5, 2014 at 4:29 AM, Ruslan Zasukhin
<ruslan_zasukhin at valentina-db.com> wrote:
> On 1/4/14, 9:32 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:
>
> Hi William,
>
>> Thanks everyone for your help. I think I learned from this that there
>> is always a solution in SQL even if your tables are not of the best
>> design.
>
>> So the lesson is you can work with badly designed tables if you know
>> something about SQL.
>
> SQL is very simple language :)
>
> Once I have try to think,
>     lets assume I hate SQL,
>     lets assume I want create new language similar to HUMAN
>     how it will looks:
>
> And I have @invent@
>
> I need SELECT some records
> FROM table
> WHERE some conditions are
> ORDER BY them
>
> Oops.  Same SQL :-)
>
>
>
> --
> 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