Re: Selecting minimum values of same column in three tables

"Erwin" <erwincisco_at_yahoo.com.sg> schrieb im Newsbeitrag news: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
> The table will look like:
>
>
> Table 1
> ID #1 ID#2
> ------ -----
> a 3
> a 5
> a 7
> b 8
> b 9
> b 10
> c 15
> c 45
> c 12
>
> Table 2
> ID #1 ID#2
> ------ -----
> a 4
> a 8
> a 1
> b 2
> b 20
> b 30
> c 25
> c 75
> c 62
>
> and other tables
>
> and the following table I need to obtain:
>
> Table Result
> 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
>

Hi Erwin,

would you please explain what exact the problem is? Do you want the min() spreaded over *all* your tables for a given column? Do you want the min() of the columns in *each* table? I don't see how your output fits in what you described above. Maybe it's because of my bad English.

Greetings,
Guido Received on Fri May 23 2003 - 08:45:49 CEST