Lutzm thanks for your suggestion. I will read.

And The factory which I'm working using Sql 2000 so I'm using Sql Server 2000 🙂

@OzYbOi d(-_-)b

Thanks for your reply I will check.

Thanks for your reply.

I need to use with join.

Can I find Max value in Where clause?

or

like this

Left outer join table1 t on t.xyz= ........ and t.xyz is max...