-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
They're used for different things. If you have a bunch of table with
the exact same fields in them that you need to lump together, do a
UNION. If you have different fields in the tables & need to get
parts of various tables all put together (most likely the case), then
you need to use JOIN.
Best regards,
Zac Bedell
> -----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/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
Comment: Please use PGP!!!
iQA/AwUBOaVDFAraVoMWBwRBEQJ8DwCg2+BQMvEQZsTPkNQjXJsNvOd6gxAAnj75
4zYFo5ClpA3nisAIji6K3Mfe
=OQ66
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.