It is a sample date..

All tableB and tableC only show for data of ID "1".

Country A has not relationship with Family A.

Yes, ID is foreign key for tableB and table...

Here is the SQL Script.. Basicailly the return rows is YxZ , Y= rows of Table B , Z = rows of Table C.

But I want the returned rows is...