I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id, c.last_name, c.first_name,
On 2012-05-21 11:17 AM, Don Wieland wrote:
I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id,
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote:
Hi all,
Is there a list/form to get some help on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is no the
appropriate forum. Thanks ;-)
Yes.
For MySQL queries,
This is the general list. If your problem is with MySQL and queries, let us
know.
Best regards.
--
WB
2010/11/29 Daniel P. Brown daniel.br...@parasane.net
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com
wrote:
Hi all,
Is there a list/form to get some help on
I have two tables EVENT and PROJECTCODE
EVENT.ID
EVENT.ID_PROJECTCODE
PROJECTCODE.ID
PROJECTCODE.Name
EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0 ID = 1
ID = 2 ID_PROJECTCODE = 0 ID = 2
ID = 3 ID_PROJECTCODE = 1 ID = 3
, November 13, 2003 2:01 PM
To: MYSQL-List (E-mail)
Subject: SELECT Query assistance please
I have two tables EVENT and PROJECTCODE
EVENT.ID
EVENT.ID_PROJECTCODE
PROJECTCODE.ID
PROJECTCODE.Name
EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0 ID = 1
ID