Re: Join Table

I dont know what u mean by joining two tables based on maximum of key.. But YES U CAN JOIN TWO TABLES BASED ON CERTAIN CRITERIA. For your case you can join these two tables like this select * from tab1, tab2
where tab1_key = tab2_key
the output will be row corresponding two tab1_key = 50 I suggest you please go through some good book on sql server. vimal

Ng K C Paul wrote:

> Is it possible to join two tables based on certain criteria? For example,
>
> tab1_key tab2_key
> -------- --------
> 10 9
> 20 18
> 30 27
> 40 39
> 50 50
>
> Table2 with key smaller or equal to table1.
>
> Can I select the maximun of key of table2 and join with table1?
Received on Fri Sep 25 1998 - 00:00:00 CDT