Thanks once again for you help. So i have to Normalize.

Basically I am looking for company having all the details of employee working in tat company( i guess your 2nd point "you want all WRegn having employee (use Inner join)")

as said this will include company details like registration number, address, number of employees and employee details.

The main purpose of this query is to display in GUI table