SELECT question

[Ruslan Zasukhin]

on 4/3/03 10:57 PM, Ken Ray at kray at sonsothunder.com wrote:

> This is very interesting, Brian. I didn't know about table aliases. Good
> stuff! However the query you provided brings back all the Entities that
> have BOTH a #1 phone AND a #2 phone; I need to bring back ALL the
> Entities, and list #1 phones if they have them, and #2 phones if they
> have them. That is, if I have 7500 Entities records, I need to get back
> 7500 lines of data with the Phone 1 and Phone 2 columns either (a)
> containing data in both columns, (b) containing data in one column, or
> (c) not containing data in either column. So I'd need to get something
> like this:
> 
> Ken Ray (tab) ABC Inc. (tab) 8005551212 (tab) 8005551213
> Jim Bim (tab) ABC Inc. (tab) 8001112233 (tab)
> Jon Doe (tab) Doe Inc. (tab)            (tab) 8002223334
> Don Row (tab) Row Inc. (tab)            (tab)
> 
> Any ideas?

Ken, there is no such straight way.

You need do some trick.
* or create tmp table
* or use special iteration method

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------