Đã hoàn thành

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

Kĩ năng: Java, MySQL, PHP, PostgreSQL, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 232 nhận xét ) Steyr Gleink, Austria

ID dự án: #18968127

Được trao cho:

okzhang321

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 Thêm

$25 USD trong 1 ngày
(53 Đánh Giá)
5.2

3 freelancer đang chào giá trung bình $23 cho công việc này

jeraldpunx112

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 Thêm

$25 USD trong 1 ngày
(2 Nhận xét)
1.2
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 trong 0 ngày
(0 Nhận xét)
0.0