Need help from SQL guru !!!!

Article View: comp.lang.basic.visual.database

Article #45

Back to comp.lang.basic.visual.database Previous Next

#45

From: Mef
Date: Tue, 24 Aug 1999 00:00

8 lines
1693 bytes

I have some problem with a SQL design.
I have a two tables - money in in first, money out at second and need to see
a result SQL, wich must have a one row per one operation (in or out of
money). If it row show a income - field of debit must to be empty, if it
show a out - field of credit must to be empty too. Any query, what i can
design - multiply a rows' qantity in one table by a rows' qantity of second
and show a repeating of values.
Is it possible to solve this task by using MSAccess? Please, help ...

Technical Details

Message-ID: <935496644.428755@spider.line.ru>

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: 115e07,db35c3e2440d61e3,start
X-Google-Attributes: gid115e07,public
X-Google-Thread: 1143a7,db35c3e2440d61e3,start
X-Google-Attributes: gid1143a7,public
X-Google-Thread: 110e3b,db35c3e2440d61e3,start
X-Google-Attributes: gid110e3b,public
X-Google-Thread: 107824,db35c3e2440d61e3,start
X-Google-Attributes: gid107824,public
X-Google-Thread: 108062,db35c3e2440d61e3,start
X-Google-Attributes: gid108062,public
From: "Mef" <mef@mail.ru>
Subject: Need help from SQL guru !!!!
Date: 1999/08/24
Message-ID: <935496644.428755@spider.line.ru>
X-Deja-AN: 516551588
Content-Transfer-Encoding: 8bit
X-Priority: 3
Content-Type: text/plain; charset=KOI8-R
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Complaints-To: hostmaster@leivo.ru
X-Trace: news.leivo.ru 935511459 42518 194.105.206.21 (24 Aug 1999 16:17:39 GMT)
Organization: Liniya Svyazi ISP
X-MSMail-Priority: Normal
Mime-Version: 1.0
NNTP-Posting-Date: 24 Aug 1999 16:17:39 GMT
Newsgroups: comp.lang.basic.visual.database,comp.lang.basic.visual.misc,cz.comp.lang.basic.visual,fj.comp.lang.visualbasic,japan.comp.lang.visual-basic