🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Query troubles

#30
From: Richard Muzerolle
Date: Mon, 15 Feb 1999 00:00
40 lines
2766 bytes
I have created the following query:

SELECT Business.BULDOWN_PH, Business.BUSOWN_PH, Business.BUS_NAM,
Business.ADDRESS, Business.MAP_ST, Business.PHONE, Business.OCCUPANCY,
Business.BUS_OWN, Business.BUILD_OWN, Business.EMG_NAM1,
Business.EMG_PHONE1, Business.EMG_NAM2, Business.EMG_PHONE2,
Business.EMG_NAM3, Business.EMG_PHONE3, Business.PREPLN_NUM,
Business.PP_LST_UPD, Business.KEY_NUM, Business.BOX_NUM,
Business.WTR_SP_NUM, Business.WTR_SP_NM3, Business.RESCUE1,
Business.ENGINE1, Business.LADDER1, Business.COVER1, Business.SPECIAL1,
Business.RESCUE2, Business.ENGINE2, Business.LADDER2, Business.COVER2,
Business.SPECIAL2, Business.RESCUE3, Business.ENGINE3, Business.LADDER3,
Business.COVER3, Business.SPECIAL3, Business.DIRCT_NUM, Business.OTHER,
Business.LST_UPDT, Directio.DIRECTIONS, Preplan.BLD_LNG, Preplan.BLD_HGT,
Preplan.BLD_WDT, Preplan.TOT_AREA, Preplan.EXPOSURES, Preplan.BLD_CONST,
Preplan.FIRE_LOAD, Preplan.ELC_SH_OFF, Preplan.GAS_SH_OFF,
Preplan.WTR_SH_OFF, Preplan.SP_CONSID, Preplan.STRATEGY, Preplan.BEHAV_PRED,
Preplan.PROBLEMS, Preplan.HAZARDS, Preplan.RES_CONSID, Preplan.STANDPIPE,
Preplan.SPRINKLER, Preplan.GPM25, Preplan.GPM50, Preplan.GPM75,
Preplan.GPM100, Preplan.ENG25, Preplan.LAD25, Preplan.ENG50, Preplan.LAD50,
Preplan.ENG75, Preplan.LAD75, Preplan.ENG100, Preplan.LAD100, Preplan.OTHER,
Hyd_flow.LOCATION, Hyd_flow.LAST_TEST, Hyd_flow.IN_OUT, Hyd_flow.MAIN_SIZE,
Hyd_flow.OTHER, Hyd_flow.FLOW_AVAIL, Business.WTR_SP_NM2
FROM "F:\Program Files\Borland\Visual dBASE\My
Projects\Dispatch\business.dbf" Business
   INNER JOIN "F:\Program Files\Borland\Visual dBASE\My
Projects\Dispatch\directio.dbf" Directio
   ON  (Business.DIRCT_NUM = Directio.DIRCT_NUM2)
   INNER JOIN "F:\Program Files\Borland\Visual dBASE\My
Projects\Dispatch\preplan.dbf" Preplan
   ON  (Business.PREPLN_NUM = Preplan.PREPLN_NUM)
   FULL OUTER JOIN "F:\Program Files\Borland\Visual dBASE\My
Projects\Dispatch\hyd_flow.dbf" Hyd_flow
   ON  (Business.WTR_SP_NUM = Hyd_flow.HYDRANT_NO)
   AND  (Business.WTR_SP_NM2 = Hyd_flow.HYDRANT_NO)
   AND  (Business.WTR_SP_NM3 = Hyd_flow.HYDRANT_NO)

My first problem is that I can not edit the table created??
My second problem is that only one of the hyd_flow.FLOW_AVAIL shows up when
I need all three in the three last lines to show??
Technical Details
Message-ID: <7a9jpu$5604@forums.borland.com>
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,1d377234ba5edb8a,start
X-Google-Attributes: gidff5a1,public
From: "Richard Muzerolle" <muzzy@muznet.net>
Subject: Query troubles
Date: 1999/02/15
Message-ID: <7a9jpu$5604@forums.borland.com>
X-Deja-AN: 444630141
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql