furs

test2.sql
Login

test2.sql

File test2.sql from the latest check-in


SELECT
    (p.name || '_' || r.name || '_' || f.name) AS peripheral_register_field,
    f.bitWidth,
    f.bitOffset,
	r.access,
    r.address,
    f.description AS field_desc
FROM
    peripheral p
INNER JOIN
    register r ON f.register_name = r.name AND f.peripheral_name = r.peripheral_name
INNER JOIN
    field f ON f.peripheral_name = p.name
WHERE
    peripheral_register_field LIKE '%reset';