[thelist] inventory database design question

Richard Bennett thelist at lists.evolt.org
Sun Mar 9 07:46:01 2003


Hi,
----- Original Message -----
From: "rudy" <r937 at interlog.com> if you are thinking of calculating profit, which i suspect from
> column names like PriceIn and PriceOut, you just have to be
> careful how you handle nulls in the serial number
>
> FIFO works in sql, but it can get complicated if all you have
> is the dates that the inventory came in
>

Thanks for reviewing that..
I'll keep your comments in mind as I refine it.

Richard.