with a join, you'll get the records that "match" something in the two
tables. With a union, the first table is output and the second table is
output right behind it so it appears to be One continuous table. The
records don't match the fields from one table to the other.
Hope this is making sense.
Bonnie
-----Original Message-----
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 11:33 AM
To: [EMAIL PROTECTED]
Subject: Join vs Union Perference
Which is a better perference, using a Join or Union?
I need to link together several tables so I can build an excel spreadsheet
Thanks for the direction.
Jim Ray
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
