Posted by jason.langdale@gmail.com on 08/08/06 14:31

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.

• Next in forum: Re: Using Union and Join in a single view
• Prev in forum: Re: How to get last date only once all have been filled in
• Thread view: Using Union and Join in a single view

[Reply to this message]