Re: [SQL] Updating Query of 1 table from data in another

2008-10-15 Thread Scott Marlowe
On Wed, Oct 15, 2008 at 8:16 AM, Chris Preston <[EMAIL PROTECTED]> wrote: > > Thanks scott > Does this work with 8.1 (that's what I'm using) > When I try to create the b table I get a message Yep. Post a self-contained example of what's not working. > ERROR: there is no unique constraint matchin

Re: [SQL] Updating Query of 1 table from data in another

2008-10-13 Thread Scott Marlowe
On Mon, Oct 13, 2008 at 1:23 PM, Chris Preston <[EMAIL PROTECTED]> wrote: > Hello all, I'm still new to postgres > > If I have 2 tables with the following data structure > > Agentno and agentname (along with many other fields) this table is called > agent_master > > And I have another table with ag