Please Help Me With This Quesry

select name.pid,name.sex

from name

where name.pid in (

select doc_11.pid

from doc_11

union

select lic_11.pid

from lic_11)

and name.sex != 'C'

Ok now I have dd_date column also in lic_doc_11 and docloc_11 table. and from those dates I have to get the max(dd_date) and display it....

also I want to take out all dates which are null or empty

please modify the above quary and let me know thatnks