If you don't use the join you get all 593 but the 89 that have a record table b are
duplicated. Right?
--mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 24, 2000 3:35 PM
> To: CF-Talk
> Subject: Re: SQL Help
>
>
> Yep. Left, right and inner joins all produce the same result.
>
> Jim
>
>
> -----Original Message-----
> From: Mark Warrick <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Sunday, September 24, 2000 4:15 PM
> Subject: RE: SQL Help
>
>
> Silly question but have you tried a right outer join?
>
> SELECT A.*, B.new
> FROM A RIGHT JOIN B ON A.areacode = B.areacode
> WHERE A.status = 'ACTIVE'
> AND B.year = 2000
>
> --mark
>
>
>
> ------------------------------------------------------------------
> ------------
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.