Re: SQL -
Posted in 1999
Sujit.Pal@bankofamerica.com — — source: Informix-list mailing list archive (1991-1998)
Alex Did you check out UNION? HTH Sujit "A. Bernaards" <Xpiet@bruynzeel.com> on 12/23/99 03:38:27 AM Please respond to "A. Bernaards" <Xpiet@bruynzeel.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: SQL - Hi All, I've got table 1 with 4 articles A, B, C, D and i've got a second table 2 with articles B, D, E, F, and I want to create a third (temp)table 3 with the articles from table 1 & 2, from A throw F. How do I manage that? I've tried a lot with temp tables, joins and outer joins but i just can't find out! Greetings Alex