postgresql command show corresponding values

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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

Java MySQL PHP PostgreSQL SQL

Project ID: #18968127

About the project

2 proposals Remote project Active 5 years ago

2 freelancers are bidding on average $23 for this job

drissijob

Hello, I am available right now. I can do the right job. You can trust me. This is my field of studies. I have 5 years experience on development. Thanks in advance. Best regards,

$20 USD in 0 days
(0 Reviews)
0.0