• Yes I had a where clause for table B.I removed it as per your suggestions and it works:-)

    Thanks for your help