I've spent a little time on this and now it's time to ask the SQL
experts.
The Scenario
-------------------
I have two tables as follows;
tblMain:
FirstName1 (varchar)
SurName1 (varchar)
Foundation (bit)
tblCentennialMembers:
FirstName (varchar)
LastName (varchar)
These are inherited and somewhat messy and there are lots more fields
(it's certainly not how I would have designed them). What I have been
asked to do is to get all foundation members from tblMain (where
foundation = Yes) as well as ALL members from tblCentennialMembers that
aren't already in tblMain. My problem is that in order to do this I want
to use FirstName1 AND LastName1 from tblMain as a comparison against
FirstName LastName and I'm pretty sure I want a union or a full outer
join (I'm thinking union), but I just cannot get this to work (oh, btw,
this is an access database - ack!).
Any ideas?
TIA
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300041
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
