Thanks for your help. My SQL statment is like this:

SELECT f.idnum, f.fidnum, i.name, f.relation FROM Family f, Identity i
WHERE f.idnum="0123456" and i.idnum=f.idnum

Could you tell me what I missed in the statement?

Thanks,

Chao-Yong