On 12 July 2010 18:34, Tommy Pham tommy...@gmail.com wrote:
SELECT srs.Name FROM SMS_R_System srs WHERE srs.SystemOUName IN
(example.com/COMPUTERS/MAIN CAMPUS/ABC, example.com/COMPUTERS/MAIN
CAMPUS/XYZ)
As this is a single table query, there is no need for the table alias.
SELECT Name FROM
I was google searching, and the only SQL mailing list I found is
currently giving a 503 error, so I hope you don't mind me asking my SQL
question here, since there are a lot of SQL gurus here. I am having a
syntax problem:
Instead of doing a query like this::
select SMS_R_SYSTEM.Name from
On Mon, 2010-07-12 at 10:24 -0500, Adam wrote:
I was google searching, and the only SQL mailing list I found is
currently giving a 503 error, so I hope you don't mind me asking my SQL
question here, since there are a lot of SQL gurus here. I am having a
syntax problem:
Instead of doing
-Original Message-
From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk]
Sent: Monday, July 12, 2010 8:26 AM
To: Adam
Cc: PHP General
Subject: Re: [PHP] help with sql statement
On Mon, 2010-07-12 at 10:24 -0500, Adam wrote:
I was google searching, and the only SQL mailing
On Thu, 2005-02-17 at 23:21, Jacques wrote:
How can I determine which users have signed in and are still on-line during
the first minute after they have signed in? My sql statement currently
reads:
SELECT * FROM tblusers WHERE usignedin = yes AND utimesignedin = (time() -
60)
Hoe does
How can I determine which users have signed in and are still on-line during
the first minute after they have signed in? My sql statement currently
reads:
SELECT * FROM tblusers WHERE usignedin = yes AND utimesignedin = (time() -
60)
Hoe does one indicate seconds in a SQL statement? Can I use
I have a database that holds a start date and an end date and I have a form
with a start date and an end date. The report would be to get everything in
the database's date ranges that overlap the form's date range. I am having
trouble figuring out how to get this to work, any help is appreciated.
On Mon, 03 Mar 2003 12:04:37 -0800, you wrote:
I have a database that holds a start date and an end date and I have a form
with a start date and an end date. The report would be to get everything in
the database's date ranges that overlap the form's date range. I am having
trouble figuring out
8 matches
Mail list logo