I have a table with two columns and I need to set a new foreign key or compound column like:
COMPOUND COLUMN 1 2
1 a B
1 a B
2 a C
2 a C
3 b D
Please elaborate clearly and say what have you done so far
Check
http://sqlzoo.net/howto/source/z.dir/tip241027/i02create.xml
http://weblogs.sqlteam.com/jeffs/archive/2007/08/23/composite_primary_keys.aspx
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.