I have some tables. One of them called COTIZACION with fields "idProveedor", "idOrdenCompra", and "fecha" (date), where "idProveedor" and "idOrdenCompra" are FK to tables PROVEEDOR and ORDENCOMPRA. When I make a query by id from ORDENCOMPRA (which is ORDENCOMPRA PK) and I get the value, I need to get the COTIZACION value that has a relationship with ORDENCOMPRA. How can I make it?
Thank you in advance.
