Concluído

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

Habilidades: Java, MySQL, PHP, PostgreSQL, SQL

Veja mais: 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

Acerca do Empregador:
( 232 comentários ) Steyr Gleink, Austria

ID do Projeto: #18968127

Concedido a:

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 Mais

$25 USD em 1 dia
(53 Comentários)
5.2

3 freelancers estão ofertando em média $23 para esse trabalho

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 Mais

$25 USD em 1 dia
(2 Comentários)
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 in 0 dias
(0 Comentários)
0.0