I have 3 tables in MySQL..One master table and 2 child tables.Master table having a primary key and its a foreign key in other 2 child tables.
Child table can have multiple details corresponding to a master data entry..1) Master table
property_id nbr_beds sqrft
1 1 2,000
2 1 2) child table 1
[ id ] [property_id] [tax_val ]
[1 ] [1 ] [ 200]
[ 1 ] [1 ] 3) child table 2
id property_id sale_val
1 1 2000
I need to take a report like how many % of records having entries for sale_val ,tax_val,sqrt like that..
I have used like select count(*),count(sqrft) from table name like that..So i will get the no of total records and the no of entries which is having value for sqrt .
But i don't know how to take it for the child tables as its having multiple entries..
I need the report as follows
Total Record count(bed) count(sqrft) count(tax_val) count(sale_val)
2 2 1 1 1
Is it possible to take a report like that??