Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|---|---|---|---|---|---|
SERVER_ID | NUMBER(38) | N | NO | NO | NO | |
ERRATA_ID | NUMBER(38) | Y | NO | NO | NO | |
ERRATA_TYPE | VARCHAR2(32) | N | NO | NO | NO |
Legend: comment string keyword reserved word operator
SELECT SNEC.server_id, SNEC.errata_id, E.advisory_type FROM rhnErrata E, rhnServerNeededErrataCache SNEC WHERE E.id = SNEC.errata_id GROUP BY SNEC.server_id, SNEC.errata_id, E.advisory_type