Dear All

It appears the problem has generated quite an interest. I am therefore attaching some sample data for Tbl1 and Tbl2. These are csv files, but as .csv files cannot...

Dear Smunson

Thanks for the interest

If you analyze the problem i formulated, I do not want to check the matched items. I want to list the rows from Tbl1 which do...

Hi maxim

Thanks again for the reply. I do not have to appear in any exam so no issue on that account. I am new to SQL. am learning it on...

Hi Maxim

thanks for the reply. replys to your questions are as under

Yes, I would appreciate your help in writing the actual quary

Yes, there are data rows in Tbl2 which do...

Thanks. It works fine now

Thankyou verymuch for the help. The function by Nicholas Cain works fine but the single line code by GilaMonster makes a mistake. it should convert time (with AM/PM suffix)...