• the other 2 tables just have data that we don't use except the companyid. so we just want to join the tables in companyid that is the same in all tables . all the other fields are in the second one ..

    thanks