How to SQL linking 1 to 1 between tables

Article View: borland.public.vdbase.data.sql

Article #136

Back to borland.public.vdbase.data.sql Previous Next

#136

From: RH
Date: Thu, 21 Jan 1999 00:00

10 lines
731 bytes

I am beginner in SQL statment
How to SQL linking 1 to 1 between tables ??
Normally, it is 1 to many rowsets, but I want to use the frist rowset only
if the field is matched.
However, I try to use SQL comman DISTINCT , it is limited to SELECE field
only 
so that I can't use other field in the same rowset .

Regarts!
allblue

Technical Details

Message-ID: <01be450f$6e451640$e41c4dca@remote>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,f972f89b4dbbce0e,start
X-Google-Attributes: gidff5a1,public
From: "RH" <s_ang@hotmail.com>
Subject: How to SQL linking 1 to 1 between tables
Date: 1999/01/21
Message-ID: <01be450f$6e451640$e41c4dca@remote>
X-Deja-AN: 435130687
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql