Article View: borland.public.vdbase.data.sql
Article #30Query troubles
From: Richard Muzerolle
Date: Mon, 15 Feb 1999 00:00
Date: Mon, 15 Feb 1999 00:00
40 lines
2766 bytes
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-mailShow 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