Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, May 1, 2026
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  SQL operation on two values from another table?

phpMyEdit General     SQL operation on two values from another table?
Post new topic   Reply to topic    
 
gstaniak     Joined: 06 Apr 2006   Posts: 7  
Post Posted: 2006-04-06 13:38
Back to top  Reply with quote     

Hi everybody,

I'm trying to set up an installation in which one column in a table would display a sum of two columns (counters) in another table. That is, if I display table A with column 'f', and counters 'x','y' are kept in table B (has to be that way, unfortunately), I would like to present column A.f as B.x + B.y (like with normal '+' arithmetic operation). I know I can use SQL expressions on table A columns, and I know i can use 'column' options for restricting user input, but it's not obvious to me how I could present sum of two columns in table B as one column in installation for table A. Is it possible at all? Thanks in advance, any help will be greatly appreciated.

Regards,
--
Grzegorz Staniak
<gstaniak@gmail.com>

 
Post new topic   Reply to topic    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy