On 2015-08-26 05:12 AM, jose isaias cabrera wrote:
> Greetings, perhaps this is not even possible...
>
> But I am trying to do something like this,
>
> WITH EmailData (name,contact,dstamp) AS
> (
>SELECT
> 'last, first',
> 'first.last at xerox.com',
> '2015-08-25 11:11:11'
> )
> UPDATE
jose isaias cabrera wrote:
> WITH EmailData (name,contact,dstamp) AS
> (
> SELECT
> 'last, first',
> 'first.last at xerox.com',
> '2015-08-25 11:11:11'
> )
> UPDATE LSOpenProjects SET XtraB = EmailData.dstamp, pmuk = EmailData.contact
> WHERE pmuk = EmailData.name;
>
> But, it's not working.
Greetings, perhaps this is not even possible...
But I am trying to do something like this,
WITH EmailData (name,contact,dstamp) AS
(
SELECT
'last, first',
'first.last at xerox.com',
'2015-08-25 11:11:11'
)
UPDATE LSOpenProjects SET XtraB = EmailData.dstamp, pmuk = EmailData.contact
WHERE
Samuel Neff wrote:
>
> Try this..
>
> SELECT p.name, sum(s.stat1), sum(s.stat2)
> FROM stats s JOIN Players p ON p.ID = s.playerID
> WHERE s.gameID IN (SELECT gameID FROM games ORDER BY gameID DESC LIMIT 5)
> GROUP BY p.playerID
>
> HTH,
>
> Sam
>
This worked! Thanks for your help Sam.
P
On 2/21/08, RBKanso <[EMAIL PROTECTED]> wrote:
>
> Assume the following table structure:
>
> http://www.nabble.com/file/p15613178/sbtables.jpg
>
> I can get overall player stats for ALL games using this select statement:
>
> SELECT p.name, sum(s.stat1), sum(s.stat2)
> FROM stats s JOIN
Try this..
SELECT p.name, sum(s.stat1), sum(s.stat2)
FROM stats s JOIN Players p ON p.ID = s.playerID
WHERE s.gameID IN (SELECT gameID FROM games ORDER BY gameID DESC LIMIT 5)
GROUP BY p.playerID
HTH,
Sam
On Thu, Feb 21, 2008 at 10:25 AM, RBKanso <[EMAIL PROTECTED]> wrote:
>
> Assume the
Assume the following table structure:
http://www.nabble.com/file/p15613178/sbtables.jpg
I can get overall player stats for ALL games using this select statement:
SELECT p.name, sum(s.stat1), sum(s.stat2)
FROM stats s JOIN Players p ON p.ID = s.playerID
GROUP BY p.ID
And I can get a
7 matches
Mail list logo