Skip to content

Instantly share code, notes, and snippets.

@radityopw

radityopw/pmp_insert_to_all_pt.sql

Created January 31, 2016 03:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save radityopw/f4836e8929b04050e7da to your computer and use it in GitHub Desktop.
Save radityopw/f4836e8929b04050e7da to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pmp_insert_to_all_pt.sql
insert into all_pt(nim,nama,pt)
select nim,nama,1 as pt
from pt1
union
select nim,nama,2 as pt
from pt2
union
select nim,nama,3 as pt
from pt3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment