MySQL FULL OUTER JOIN on INFORMATION_SCHEMA.COLUMNS & INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Question

I'm looking to JOIN the following SELECT statements.

query 1

SELECT
    TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_TYPE, IS_NULLABLE, ORDINAL_POSITION
FROM
    INFORMATION_SCHEMA.COLUMNS
WHERE
    TABLE_SCHEMA = '<database>'
ORDER BY
    TABLE_NAME, ORDINAL_POSITION;

query 2

SELECT
  TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME, CONSTRAINT_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_SCHEMA = '<database>';

Both of these queries return the desired results when ran separately.

Here's what I think was my best attempt at using a FULL INNER JOIN

SELECT
    COLUMNS.TABLE_NAME, COLUMNS.COLUMN_NAME, COLUMNS.DATA_TYPE,
    COLUMNS.COLUMN_TYPE, COLUMNS.IS_NULLABLE, COLUMNS.ORDINAL_POSITION,
    USAGE.REFERENCED_TABLE_NAME, USAGE.REFERENCED_COLUMN_NAME, USAGE.CONSTRAINT_NAME
FROM
    INFORMATION_SCHEMA.COLUMNS AS COLUMNS
WHERE
    TABLE_SCHEMA = '<database>'
FULL OUTER JOIN
    INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS USAGE
ON
    COLUMNS.TABLE_NAME=USAGE.REFERENCED_TABLE_NAME
ORDER BY
    COLUMNS.TABLE_NAME, COLUMNS.ORDINAL_POSITION;

I haven't worked with JOINS much, and I keep getting a SYNTAX error... Any help or guidance would be appreciated.

Thank you