Re: [GENERAL] How to join to delete

2006-05-02 Thread Chris Velevitch
On 5/2/06, Richard Huxton wrote: Chris Velevitch wrote: > I'm using pg 7.4.5 on Win XP SP1. The first official release for Windows was 8.0, and there have been I'm the cygwin version of pg for testing. several bugfixes to 7.4.x since then. Upgrade as soon as is practical. I'm deploying to

Re: [GENERAL] How to join to delete

2006-05-02 Thread Richard Huxton
Chris Velevitch wrote: I'm using pg 7.4.5 on Win XP SP1. The first official release for Windows was 8.0, and there have been several bugfixes to 7.4.x since then. Upgrade as soon as is practical. I want to delete rows from a table B, but need to join it to another table A in order to select

Re: [GENERAL] How to join to delete

2006-05-02 Thread Noel Faux
Hi Chris, I think the best bet would be to use a nested select: Delete from A WHERE A.bk = (SELECT bk FROM B) where A.ak = x; Cheers Noel Chris Velevitch wrote: I'm using pg 7.4.5 on Win XP SP1. I want to delete rows from a table B, but need to join it to another table A in order to select t