Re: OT: joining tables

[KChapman]

You need to join the tables.  There has to be a field in both tables that
has the same data like client id.  Is there such a field?

--Katrina

====================
Katrina Chapman
Consultant
Ameriquest Mortgage



                                                                                       
                                         
                    Shawn Regan                                                        
                                         
                    <shawnr@pts1.        To:     "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]>                      
                    com>                 cc:                                           
                                         
                                         Subject:     OT: joining tables               
                                         
                    05/02/00                                                           
                                         
                    09:24 AM                                                           
                                         
                    Please                                                             
                                         
                    respond to                                                         
                                         
                    cf-talk                                                            
                                         
                                                                                       
                                         
                                                                                       
                                         



This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFB452.F8791E40
Content-Type: text/plain;
           charset="iso-8859-1"

hey people,

i'm doing a join in this query:

SELECT  CLIENTS.CLIENT_NAME, PRODUCTS.PRODUCT_NAME, CATEGORY.CAT_ID,
CATEGORY.CATEGORIES
FROM CLIENTS, PRODUCTS, CATEGORY
WHERE CLIENTS.CLIENT_NAME='#session.client#'

I have only one record in the database right now for testing. so there is
only one client. But this query keeps pull out the one client as two
different clients.

I can't figure it out.

Shawn Regan



------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.