Query, View+S.proc

Article View: borland.public.interbase.sql

Article #826

Back to borland.public.interbase.sql Previous Next

#826

From: Serra
Date: Mon, 14 May 2007 14:50

23 lines
1285 bytes

IB 6.02,

I have a View and returns
SMONTH    EXPENCIES
01                  100
02                  500

i have also a S.proc and returns
SMONTH    PROFIT
01                   500
02                   600

i have also have a table MONTHS
01  January
02 February
....

is it possible to get below result from them
SMONTH      PROFIT   EXPENCIES   NETPRO.
01                     500               100            400
02                     600               500            100

Thank you.

Technical Details

Message-ID: <46487708$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,52c88fc22ed35694,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Serra" <nomail@nomail.com>
Newsgroups: borland.public.interbase.sql
Subject: Query, View+S.proc
Date: Mon, 14 May 2007 17:50:01 +0300
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 81.214.131.112
Message-ID: <46487708$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1179154184 81.214.131.112 (14 May 2007 07:49:44 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail