postgresql command show corresponding values

i have sql command and want to show for category_id, type and plattform sold not id but corresponding name command select id2, name, street, category_id, type, plattform_sold, archivedate from assets where published=2 order by archivedate desc table assets id street category_id (need [login to view URL] here) type (need [login to view URL] here) platform_sold (need [login to view URL] here) category table id, name, type table id, name plattform table id, name