Hi Thanks for the reply.

Yes. from the query we need to remove 'and'.

The column datetime1 in both the table is of type datetime.

The values which are present are like '2013-02-04 10:45:00.000', '2013-02-10 18:45:00.000', '2013-04-01 09:20:00.000', etc. From this value, I want to retrieve in the form of hours and minute.

The end result values will be

10:45, 18:45, 09:20, etc.

Could you please help me out to get the result in the above form?

Thanks in advance.