🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Details on SELECT

#1601
From: GLENN DREDDEN
Date: Wed, 05 Nov 1997 00:00
32 lines
1759 bytes
Greg,
  the programmer's guide has a whole section on SQL, to include using the
Select command.  You
will find SQL is very easy to use and there are not many basic commands to
learn.  Also when you use  help at the command windows it gives you two
selections Select and Select(local SQL).  If you pick the latter Visual
dBase will give you an very detailed explanation of the Select command.  In
addiition you can also  display example of using the command.  
I hope this helps...

Glenn

Greg Hill <ghill@n2.net> wrote in article <345F12B6.6FEE@n2.net>...
> I have noticed that there is undocumented usage of the SQL command 
> SELECT, at least in my installation of Visual Dbase 5.5.
> 
> For example:
> 
> I do not see any mention under HELP|SELECT.  That talks about the 
> meaning or usage of LEFT OUTER JOIN, RIGHT OUTER JOIN, INNER JOIN...
> The list might go on? If I knew SQL I wouldn't mind as much I would just 
> try the commands and see if they work.  I'm very interested in finding 
> complete documentation on Local SQL.  I'm having some trouble getting 
> the results I want using SELECT.  I called a friend who knows a little, 
> he proceeded to find some answers for using MS Access.
> 
> Is there any .HOW files out there or something that will help me use SQL 
> statements??
> 
> Thanks, Greg
> 
Technical Details
Message-ID: <01bcea3f$d95b2680$e69a3481@theman.wpafb.af.mil>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <345F12B6.6FEE@n2.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,752e9937407662f3
X-Google-Attributes: gidff5a1,public
From: "GLENN DREDDEN" <dreddeg@wpdiss1.wpafb.af.mil>
Subject: Re: Details on SELECT
Date: 1997/11/05
Message-ID: <01bcea3f$d95b2680$e69a3481@theman.wpafb.af.mil>
X-Deja-AN: 287277316
References: <345F12B6.6FEE@n2.net>
Organization: USAF
Newsgroups: borland.public.vdbase.data.sql