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, c.l
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,
MIN(apt.time_sta
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
> On Mon, Nov 29, 2010 at 14:35, Don Wieland
> wrote:
> > Hi all,
> >
> > Is there a list/form to get some help on compiling mySQL queries? I am
> > executing them
On Mon, Nov 29, 2010 at 14:35, Don Wieland 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, write to the MySQL
oisy
Sent: Thursday, 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
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
