Re: [SQL] Help with "missing FROM clause" needed

[Richard Huxton]

Thomas Beutin wrote:

Hi,

to be compatible with the postgres standard syntax in 8.1.x i need some help for rewriting my "delete" statements ("select" is not a problem). I use the following statement:

DELETE FROM partner_zu
WHERE partner_zu.pa_id = partner.id
AND partner_zu.m_id = '25'
AND partner.open = 'm'
AND partner.a_id = partner_zu.a_id
AND partner_zu.a_id = '104335887112347';

DELETE FROM partner_zu
WHERE
  partner_zu.m_id = '25'
  ...etc...
  AND partner_zu.pa_id IN (
    SELECT id FROM partner WHERE open='m' AND a_id='104335887112347'
  )

Does that work for you?

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster