Results 1 to 3 of 3

Thread: [Resolved]mysql question

Threaded View

  1. Mar 7th, 2007, 07:45 PM #1
    kfcSmitty
    kfcSmitty is offline

    Thread Starter
    PowerPoster kfcSmitty's Avatar
    Join Date
    May 2005
    Posts
    2,248

    Resolved [Resolved]mysql question

    Is it possible to do something like this:

    Select (amount*days*people) as totalCost, sum(amtPaid) as amountPaid, (amountPaid - totalCost) as thisparthere?


    Where I compute 2 fields and then do a calculation on them? I have been trying it, but I can't find a way to do it.

    Would I have to use a temporary table or a view?
    Last edited by kfcSmitty; Mar 7th, 2007 at 11:58 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width