I would redo your DDL and follow ISO 11179 naming rules. You don't need a row identifier, so we can drop one of the columns. You also need to enforce...

There is a good set of stories about the exists () predicate. The first implementations in Oracle actually worked out the SELECT statement without any optimizations. This meant that a...

>> Well, the issue with MONEY is that who's to say monetary amounts should always have 4 decimals? <<

GAAP (generally accepted accounting practices) in the US and some EU regulations....

>> All I hear when you talk anymore is the teacher from Charlie Brown cartoons.<<

Perhaps you want to take the wax out of your ears. You have a chance to...

I'm talking about the ANSI ISO Standard SQL. We debated allowing other ISO – 8601 display formats and settled on "yyyy-mm-dd" as the one and only to use. Our reasoning...

>> ... the date should look like 1/4/2020, in a date format. <<

Actually, the ANSI/ISO Standards say that it ought to look like "2020-01-04", or maybe "2020-04-01"; you've picked one...

>> Two Tables <<

where is the DDL for these tables? We need to know the keys, the datatypes of the columns, the constraints and the references. What you posted is...

>> I've only been in IT for 15 years and at the ripe age of 48, I know that's a very short time for many of you,.

LOL! I have socks...

>> While I understand and may even agree with your assessment about the terms used, there's not a Roman Numeral in sight. No need to resort to all that passive-aggressive...

Many years ago, SQL Server changed the definition of the bit data type from {0, 1}, which is what most of us older computer types would think a bit is,...

>> I've always understood that when you have a parent [referenced] and child table where the parent [referenced] tables primary key is referenced by the child tables foreign key then...

>> Given the request, pretty sure that debit and credits represent units in inventory NOT currency. <<

Why would you say "debit" and "credit" which are terms from accounting? What

about "restock"...

It would've been nice if we've gotten usable DDL. Did you read the requirements for posting DDL on forums? Apparently you don't seem to know that we need to have...

I want to run a query to get a true or false value.. true if the datetimes in the table are in date order, and false if they are not...

Ask as many questions as you wish, but please follow the forum rules and post DDL try to follow standards and show us what you tried on your own before...