update one table with another

Поиск
Список
Период
Сортировка
От Matthew Pugsley
Тема update one table with another
Дата
Msg-id 873251980904201334w1bb49ad4s5fdc9992fab1c09f@mail.gmail.com
обсуждение исходный текст
Ответы Re: update one table with another  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Список pgsql-general
I've solved it.
 
I just used a subselect. Worked very quickly. I had a lot of trouble with subqueries when I first started databases with MySQL. So I have been afraid of them.
 
update entities
set customer_status = select(customer_status from entity_dimension_update where entities.entity_id = entity_dimension_update.entity_id);
 
Worked almost instantly.
 
My apologies for the spam.

--
matthew.pugsley@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Doubt about join clause
Следующее
От: Mikko
Дата:
Сообщение: trouble with to_char('L')