select in computed by field

Article View: borland.public.interbase.sql

Article #877

Back to borland.public.interbase.sql Previous Next

#877

From: Moore
Date: Sun, 17 Jun 2007 10:21

12 lines
1291 bytes

in a computed by field i put the following select, to calculate the 
multiplication of a a field in a table with another field in another 
table by a join, but in all the rows it shows the result of the first 
field, in all rows,

(select articulos.ud_medida * salidas.cantidad_sal
from articulos, SALIDAS
where articulos.id_artic = salidas.id_artic)

all rows of salidas show the same value for this field, where it should 
not be, how to metion the value of a field in the current row in the 
computed by field?

Technical Details

Message-ID: <46750b19$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,91a82909dabc9368,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 17 Jun 2007 12:21:12 +0200
From: Moore <delfino03@caramail.com>
User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: select in computed by field
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 88.18.215.153
Message-ID: <46750b19$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182075673 88.18.215.153 (17 Jun 2007 03:21:13 -0700)
Lines: 12
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