On Sep 2, 2015, at 11:02 PM, Ethan Rosenberg
wrote:
> Dear list -
>
> I know that I am making a mistake somewhere. but am lost for an answer.
>
> mysql> select Payments from Charges where if(Payments, Payments, 0);
> +--+
> | Payments |
> +--+
> |13.00 |
> |55.00 |
>
On 09/01/2015 11:43 PM, Aziz Saleh wrote:
On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg <
erosenb...@hygeiabiomedical.com> wrote:
Dear List -
I have a payment/charges table -
mysql> describe Charges;
+--+--+--+-+-+---+
| Field| Type
On Sep 1, 2015, at 10:36 PM, Ethan Rosenberg
wrote:
> Dear List -
>
> I have a payment/charges table -
>
> mysql> describe Charges;
> +--+--+--+-+-+---+
> | Field| Type | Null | Key | Default | Extra |
> +--+--
On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg <
erosenb...@hygeiabiomedical.com> wrote:
> Dear List -
>
> I have a payment/charges table -
>
> mysql> describe Charges;
> +--+--+--+-+-+---+
> | Field| Type | Null | Key | Default
Dear List -
I have a payment/charges table -
mysql> describe Charges;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| Indx | mediumint(9)