Ygthkb

What is the Buddhist view in Socratic questioning?

How bad is a Computer Science course that doesn't teach Design Patterns?

Is there any way to play D&D without a DM?

Is the tritone (A4 / d5) still banned in Roman Catholic music?

Can a Way of Shadow Monk use Shadow Step to teleport to a dark ceiling and then body slam another creature?

I am a loser when it comes to jobs, what possibilities do I have?

What is the reward?

Disk space full during insert, what happens?

SQL Server Service does not start automatically after system restart

Is Screenshot Time-tracking Common?

Is there any danger of my neighbor having my wife's signature?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Do the speed limit reductions due to pollution also apply to electric cars in France?

What happens if both players misunderstand the game state until it's too late?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Multiple null checks in Java 8

What is an explicit bijection in combinatorics?

What does @ mean in a hostname in DNS configuration?

How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?

What sort of grammatical construct is ‘Quod per sortem sternit fortem’?

Did ancient Germans take pride in leaving the land untouched?

Why does this quiz question say that protons and electrons do not combine to form neutrons?

How to deal with an underperforming subordinate?

Why write a book when there's a movie in my head?

I need to find mismatches between tables

Find the salary difference between two monthsComparing values between two tablesMoving a date between tables is causing error ORA-01841How do I find gaps between ranges of numbers?Connecting 4 tables - finding some differences between themNeed SQL outer join help with 3 tablesOracle Table - game like script - need solution to find out the values from current columnFind jobs and dependencies run between two timestampsHow to find which tables were deleted (in Oracle)Finding the odd row between two tables in Oracle

0

So my problem is basically that I have an accounting table that has transaction references, and supporting document numbers. Some of the document numbers have become mismatched from their actual transaction number. The worst part is that the bad document numbers are actually valid, but reference a bad transaction. So here's the important part:

Every transaction has two parts.
Reference#, Type (Type A and Type B), and a document number.

I need to find all transactions where either (REF#, Type A)'s DOC# doesn't equal (REF#, Type B)'s DOC#, or where there is no matching Type A or Type B transaction at all.

oracle

share

asked 9 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

So my problem is basically that I have an accounting table that has transaction references, and supporting document numbers. Some of the document numbers have become mismatched from their actual transaction number. The worst part is that the bad document numbers are actually valid, but reference a bad transaction. So here's the important part:

Every transaction has two parts.
Reference#, Type (Type A and Type B), and a document number.

I need to find all transactions where either (REF#, Type A)'s DOC# doesn't equal (REF#, Type B)'s DOC#, or where there is no matching Type A or Type B transaction at all.

oracle

share

asked 9 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

So my problem is basically that I have an accounting table that has transaction references, and supporting document numbers. Some of the document numbers have become mismatched from their actual transaction number. The worst part is that the bad document numbers are actually valid, but reference a bad transaction. So here's the important part:

Every transaction has two parts.
Reference#, Type (Type A and Type B), and a document number.

I need to find all transactions where either (REF#, Type A)'s DOC# doesn't equal (REF#, Type B)'s DOC#, or where there is no matching Type A or Type B transaction at all.

oracle

share

asked 9 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 9 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 9 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

MatthewMatthew

1