How to INSERT INTO with SELECT and default values
Hi friends, can't find related material online.
Question, I have a table with column a, b and c, a is a sequence and b is defaulted to be say 0.
I take column c from a SELECT clause.
How do I do this kind of things?
INSERT INTO table
This doesn't work. Any idea? Thanks!