with no comma (sorry):
select
sum(a.attendhours),
s.attendhours
from
attendance a,
attsum s
where
a.siteid = s.siteid and
a.assignmentid = s.assignmentid and
a.attenddate = s.attenddate and
a.siteid = 'XXX' and
a.attenddate >= '-XX-XX'
group by
a.assignmentid,
hi,
you can add
...
...
group by
a.assignmentid,
a.attenddate;
having sum(a.attendhours) != s.attendhours
Mathias
Selon Scott Pippin <[EMAIL PROTECTED]>:
> I have the following query.
>
> select
> sum(a.attendhours),
> s.attendhours
> from
> attendance a,
> attsum s
> where
> a.
: Tuesday, March 04, 2003 4:58 PM
To: Bob Ramsey
Cc: [EMAIL PROTECTED]
Subject: Re: help with join syntax
Hi.
This is not at all an answer to your problem,
and perhaps you're already aware of my tip:
I usually use phpMyAdmin and paste my SQL statements
in there to see what is causing the
At 03:57 PM 3/4/2003, Martin Ostlund wrote:
I usually use phpMyAdmin
Thanks for the tip. Unfortunately it isn't my server and they haven't
finished installing phpMyAdmin on it yet. That's why I usually make odbc
connections in access and build the queries graphically. But it just keeps
cho
Hi.
This is not at all an answer to your problem,
and perhaps you're already aware of my tip:
I usually use phpMyAdmin and paste my SQL statements
in there to see what is causing the error, and when it works
you get a pretty good picture of how your "virtual" table
looks like.
Just my 2 cents.
* Peter Engström
> I have an table called 'list' where I store all items for the pulldown
> menues on my site.
>
> Table list has three columns
> - id (int autoincrement)
> - pulldown_name (tinytext - name of pulldown)
> - item (tinytext - the item for the pulldown menu)
>
> A table called clie
Jeff,
> What i want to do seems simple, but i can not for the life of me
figure out
> how to do it.
> Tables: These tables are not related in any way.
>
> A
> --
> 1
> 2
> 3
> 4
> 5
>
> B
> --
> 1,Bob
> 3,Jack
> 7,Janet
> 8,Gary
> 9,Kelly
>
> I would like to combine tables A and B with a SELECT
Hi David,
Does this work for you?
select customer.custcode, bookings.cust from customer left join bookings on
customer.custcode=bookings.cust
group by (customer.custcode) having max(ifnull(bookings.stdt,'-00-00')
<= '2002-02-16';
Regards,
Anvar.
At 09:06 PM 26/02/2002 +, you wrote:
>
- Original Message -
From: "John Mayson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, December 22, 2001 10:11 AM
Subject: Help with join
> I'm still in the learning mode with mySQL.
>
> I have two tables (frequencies and agencies), both contain a column called
