Difference between JOIN and UNION

Common questions about 1C:Query language, Query builder tool and Data composition schema

Pages: 1

Yi Gang	#1 People who like this:0 Yes/0 No Dec 04, 2012 12:00 PM
Just came Rating: 1 Joined: Dec 4, 2012 Company: China Welfare Lottery	Hi！ I am very new to programming。 Can you please explain me the difference between JOIN and UNION？

ivan avdonin	#2 People who like this:1 Yes/0 No Dec 04, 2012 12:14 PM
Active user Rating: 7 Joined: Sep 26, 2012 Company: individual	I think this picture can help understand it. and also for easy it can be said that "join" is horisontal union (adding columns), and "union" is vertical union (adding lines) Attached Files Download pic00011.PNG (13.86 KB) Edited: ivan avdonin - Dec 04, 2012 12:20 PM

Yi Gang	#3 People who like this:0 Yes/0 No Dec 04, 2012 12:35 PM
Just came Rating: 1 Joined: Dec 4, 2012 Company: China Welfare Lottery	Thank you！

Subscribe

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)