SQL Question

Article View: bit.listserv.sqlinfo

Article #290

Back to bit.listserv.sqlinfo Previous Next

#290

From: David D�nomm�e
Date: Wed, 29 Aug 2001 02:01

19 lines
1721 bytes

Hi,

    I'm not sure if I'll receive an answer here after looking the number of
posts, but I'll try!!!

    I have 3 tables : workorders, equipments and locations.  Theses 3 tables
have primary keys and the workorders tables have locations and equipments
field.  These key are wonum, eqnum and location.

    I would like to have the wonum and description of the equipements and
locations from the workorders but the code in workorders could be null.  I
try to do a join with the (+), but I could only have one in the query.  So,
for the moment, I use 3 Select statements with 2 Union, pis I pretty sure
that I can do this by another way.

    If you have an answer for me, I could really like it!!

Thanks
David

Technical Details

Message-ID: <e4Yi7.35411$zP.2358850@news20.bellglobal.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!newsfeed.gamma.ru!Gamma.RU!newsfeed.sovam.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,eeb78c5545c27be6,start
X-Google-Attributes: gid11355a,public
X-Google-ArrivalTime: 2001-08-28 19:04:01 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!newsfeed.gamma.ru!Gamma.RU!newsfeed.sovam.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
From: "David D�nomm�e" <ddenommee@hotmail.com>
Newsgroups: bit.listserv.sqlinfo
Subject: SQL Question
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <e4Yi7.35411$zP.2358850@news20.bellglobal.com>
Date: Tue, 28 Aug 2001 22:01:33 -0400
NNTP-Posting-Host: 64.229.209.181
X-Complaints-To: abuse@sympatico.ca
X-Trace: news20.bellglobal.com 999050634 64.229.209.181 (Tue, 28 Aug 2001 22:03:54 EDT)
NNTP-Posting-Date: Tue, 28 Aug 2001 22:03:54 EDT
Organization: Bell Sympatico