View previous topic :: View next topic
|
Author |
Message |
venkatm99
New User
Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore
|
|
|
|
Hi
AA721T - bcm,seq-no
AA723T - bcm,seq-no
I need to fetch the max(seq-no) from the 2 tables.
pl help
cheers
venkat |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Hi,
This should work, If I understand your requirement correctly..:-)
SELECT MAX(SEQ-NO) FROM TABLE
(SELECT SEQ-NO FROM AA721T
UNION
SELECT SEQ-NO FROM AA721T) AS T1; |
|
Back to top |
|
|
venkatm99
New User
Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore
|
|
|
|
Thanks Sri
cheers
venkat[/code] |
|
Back to top |
|
|
|