Hi gary,

thanks a lot for that suggestion. I have done what u said. created a codetypemaster table. here is what I have comeout with

select * from codetypemaster CTM join...

HI,

I could have done with inner joins,but my main concern is if I have say 50 fields, would I require to have 50 inner joins for each field in details...

It is a good idea to query date fields using yyyy/mm/dd format to get the correct result. for eg. if your regiional setting is mm/dd/yyyy and date is stored in...