ot;)
Veln
- Original Message -
From: "Johnny Withers"
To: "Velen Vydelingum"
Cc:
Sent: Sunday, July 24, 2011 17:41
Subject: Re: Query bug
What's your vb code for outputting the results look like?
On Jul 24, 2011 8:22 AM, "Velen Vydelingum"
Hi,
I have the following query which is fine when I run it from the mysql shell
screen:
select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
paymentdate<='2010-12-02' and grnno not in (Select sale_id from saletrans_cons
where paymode='Credit') group by supplier_code
but w
Hi,
I have 2 tables and need to create a 3rd one as follows:
Table Sales:
Code Price sQtysDate
12312.0022011-03-12
19010.0012011-03-14
12313.0022011-03-29
12313.0032011-03-31
19011.0022011-03-31
Table Costs
Hi,
I have 2 tables:
Sales> Code, Price, sDate
History>Code, Cost, hDate
The sales record sales for each product by its code. The History table has the
cost history of each product at different date.
I need to know the last cost of each product in the sales table at the date of
the sales.
Ca
