Startseite › Update a join?

Reply to comment

Update a join?

2 June, 2007 - 08:55 — Dirk 
update 
  (select columnName, value
     from name, lookup
     where name.keyname = lookup.keyname
       and lookup.othercolumn = :other_value)
  set column_name = value;

Reply

The content of this field is kept private and will not be shown publicly.
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • You may post PHP code. You should include <?php ?> tags.

More information about formatting options