Using Union and Join in a single view

Giganews Newsgroups
Subject: Using Union and Join in a single view
Posted by:  jason.langda…@gmail.com (jason.langda…@gmail.com)
Date: 8 Aug 2006

I have 3 tables I want to use in a view. Table A has field 1,2,3,4,5
and table B has field 1,2,3,4,5. I want to do a union on these. (I have
done so successfully if I stop here) I also want to join table C which
has field 1,6,7,8,9. I would like to join on field 1 and bring in the
other fields. I can join table C to A or B. I can union table A and B
but I do not know how to both union A and B then join C. Can someone
please help me? Thanks in advance.

Replies