SELECT t1.id, t1.name, t2.production, t2.[...], t2.[...] FROM <table_1> t1, <table_2> t2 WHERE t2.company_id=t1.id