select a.*,b.companyid,hsno,b.phone1,b.phone2,b.phone3,b.fax1,b.fax2,b.businessline,b.companyname as companyname, b.building,b.street,b.suburb,b.city,b.province,b.postcode,b.email,b.agent,b.distributor,b.exporter,b.importer,b.manufacturer, b.service,b.supplier,b.trader,b.groups,b.producer,b.retailer from executives as a, companydetails as b where b.companyid=a.companyid and a.executiveid='68675'