Hello all, I have a table that contains columns that describe an item. E.g.
ITEM table
ID bigint not null
COLOUR bigint not null (indexed)
FINISH bigint (indexed)
Then another table that contains a qty of items that is reserved. I.e. the
specification and qty of items reserved.
31.10.2014 09:03, 'Louis van Alphen' wrote:
and coalesce(R.FINISH,-1) = coalesce(STOCK.FINISH,-1)
and R.FINISH is not distinct from STOCK.FINISH
Dmitry
Thanks! Never too old to learn
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 31 October 2014 09:13 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Equality on NULL column values
31.10.2014 09:03, 'Louis van Alphen'