WillyVervest
/
How_to_insert_update_and_delete_data
forked from bdelepeleer/How_to_insert_update_and_delete_data
Watch 1
Star 0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
6 Commits
1 Branch
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
How_to_insert_update_and_de.../exercise-8.sql

exercise-8.sql 125B
Raw Permalink Blame History

123456 
  1. UPDATE invoices

  2. SET terms_id = 2

  3. WHERE vendor_id IN

  4.     (SELECT vendor_id

  5.      FROM vendors

  6.      WHERE default_terms_id = 2)