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

Beceriler: Java, MySQL, PHP, PostgreSQL, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 232 değerlendirme ) Steyr Gleink, Austria

Proje NO: #18968127



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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(53 Değerlendirme)

Bu iş için 3 freelancer ortalamada $23 teklif veriyor


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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)

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 gün içinde
(0 Değerlendirme)