I have multiple select and join SQL queries and I want to return a single result set in MySQL

SELECT COUNT(*) FROM SYSTEM.PARTITIONEDTABLES where schema=? and TABLENAME=?

SELECT PC.SCHEMA, PC.TABLENAME, PC.PARTITIONNAME, PC.ISDEFAULT, PC.VALUE,PT.PARTITIONTYPE, PT.PARTITIONINGCOLUMN, PT.DEFAULTPARTITION, PI.STORAGEGROUP FROM SYSTEM.PARTITIONCRITERIA PC JOIN SYSTEM.PARTITIONEDTABLES PT ON PC.TABLENAME=PT.TABLENAME AND PC.SCHEMA=PT.SCHEMA JOIN SYSTEM.PARTITIONIDS PI ON PC.TABLENAME=PI.TABLENAME AND PC.SCHEMA=PI.SCHEMA AND PC.PARTITIONNAME=PI.PARTITIONNAME WHERE PC.SCHEMA='' AND PT.TABLENAME=''