Forum Discussion

S2861926's avatar
S2861926
Regular Visitor
4 years ago

How to correlate more rows in the same table with unique ID

Hi, in a table (SQL database) I have the double-entry bookkeeping (accounting movements) as shown in the attached figure:                           I want to correlate all the mo...
Need Help
NilR's avatar
NilR
Icon for Post Patron rankPost Patron
4 years ago

So doesn't have to be static you can make a dynamic table ,a portion of your current query/table  , something like this:

 

Select Distict Registration ID, Customer Name,

from Table

;

 

 

S2861926's avatar
S2861926
Regular Visitor
4 years ago

sorry but i can't understand what you mean ... could you be more specific?