Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Executing the following query will show you the existing reference data

Code Block
SELECT *l.lookup_id, le.entity_name, l.lookup_name, le.description
FROM lookup_value l
INNER JOIN lookup_entity le
ON l.entity_id=le.entity_id
order by l.entity_id, l.lookup_id;

...