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


select id2, name, street, category_id, type, plattform_sold, archivedate from assets where published=2 order by archivedate desc

table assets



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

Evner: Java, MySQL, PHP, PostgreSQL, SQL

Se mere: postgres values, mysql create temporary table from list of values, postgres check if in list, postgres sql in list, list of strings postgresql, postgres array, postgres cte values, postgres virtual table, sql last recent order, write sql queries customer order tables, vba listbox values append sql, sql latest customer order, create sql database customer order details code, sql find latest order number, sql error 1064 order pdproducts_name line, sql days last order, instalar sql com sort order, net null values saving sql, copy data command stored procedure ms sql, insert reference bash shell comments authoraccept positional parameters command linedisplay values screendisplay usage clause in

Om arbejdsgiveren:
( 232 bedømmelser ) Steyr Gleink, Austria

Projekt ID: #18968127

Tildelt til:


Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time. I am well experienced and skillful Java and postgreSQL programmer. I Flere

$25 USD på 1 dag
(53 bedømmelser)

3 freelancere byder i gennemsnit $23 på dette job


Hi, my name is Jerald and I'm graduated at University of San Jose-Recoletos on Cebu, Philippines,. I studied BS Information Technology major on Web Developer because Its my passion to develop some kind of websites and Flere

$25 USD på 1 dag
(2 bedømmelser)

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 dage
(0 bedømmelser)