SELECT QUOTATIONS.DATE_RATES ; , QUOTATIONS.IDQUOTATIONS ; , CLIENT.NAME ; , QUOTATIONS.STATUS ; , QUOTATIONS.TYPE_DE_QUOTATION ; , SERVICE.TYPE AS TYPE_DE_SERVICE ; , QUOTATIONS.CONTACT_ID ; , QUOTATIONS.DEPART ; , QUOTATIONS.ARRIVER ; FROM QUOTATIONS ; LEFT JOIN CLIENT ON CLIENT.IDClient = QUOTATIONS.CLIENT_ID ; LEFT JOIN SERVICE ON SERVICE.IDSERVICE = QUOTATIONS.TYPE_DE_QUOTATION