SQL help
william humphrey
bill at bluewatermaritime.com
Sun Feb 1 15:36:47 CST 2015
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
More information about the Valentina
mailing list