SSSFisgard
Technical User
- Nov 7, 2006
- 27
Hi guys,
I'm needing a little help. CRXI R2 user, on a sql database. I have a table with a number of transactions and transaction codes. I need to just display the lastest record with the certain transction code. I'll show an example.
Row Trans date Code Amount
5 18-sep-07 adv 100,000
6 18-sep-o7 int 5,000
7 19-sep-07 adv 100,000
8 20-sep-07 int 5,000
I need to just display Row 7 and all its "parts". Date, amount, code ect.
If someone could help me out that would be awesome.
SS
I'm needing a little help. CRXI R2 user, on a sql database. I have a table with a number of transactions and transaction codes. I need to just display the lastest record with the certain transction code. I'll show an example.
Row Trans date Code Amount
5 18-sep-07 adv 100,000
6 18-sep-o7 int 5,000
7 19-sep-07 adv 100,000
8 20-sep-07 int 5,000
I need to just display Row 7 and all its "parts". Date, amount, code ect.
If someone could help me out that would be awesome.
SS