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
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.
pgsql-general by date
|Next:||From: Mikko||Date: 2009-04-20 21:00:07|
|Subject: trouble with to_char('L')|
|Previous:||From: Bill Moran||Date: 2009-04-20 20:28:32|
|Subject: Re: Doubt about join clause|