Selecting minimum values of same column in three tables
Date: Fri, 23 May 2003 03:19:59 GMT
Message-ID: <zrgza.1719$iv4.19428_at_news-server.bigpond.net.au>
Hi,
I encountered the problem when I need to select the minimum values of the
same column in the three tables
Table 1
Table 2
and other tables
and the following table I need to obtain:
Table Result
The table will look like:
ID #1 ID#2
------ -----
a 3
a 5
a 7
b 8
b 9
b 10
c 15
c 45
c 12
ID #1 ID#2
------ -----
a 4
a 8
a 1
b 2
b 20
b 30
c 25
c 75
c 62
ID #1 ID#2
------ -----
a 3
a 5
a 1
b 2
b 9
b 10
c 15
c 45
c 12
Thanks for the comments in advance Received on Fri May 23 2003 - 05:19:59 CEST