Anyone any good at SQL?

[MattB]

Try putting those other columns it's complaining about at the end of the GROUP BY list

[andyc209]

Done it...cheers

SELECT TOP 100 PERCENT MAX(dbo.faxlog.Col004) AS Expr1, dbo.faxlog.Col003, MAX(dbo.faxlog.Col005) AS Expr3, MAX(dbo.faxlog.Col007) AS Expr2, MAX(dbo.faxlog.Col008) AS Expr4, MAX(dbo.faxlog.Col009) AS Expr5, MAX(dbo.faxlog.Col010) AS Expr6, MAX(dbo.faxlog.Col011) AS Expr7, MAX(dbo.faxlog.Col012) AS Expr8, MAX(dbo.ZFAXerror.Description) AS Expr9
FROM dbo.faxlog INNER JOIN dbo.ZFAXerror ON dbo.faxlog.Col008 = dbo.ZFAXerror.Hex
GROUP BY dbo.faxlog.Col004, dbo.faxlog.Col003
HAVING (dbo.faxlog.Col003 = 'mpp') AND (MAX(dbo.faxlog.Col004) < '999999')
ORDER BY dbo.faxlog.Col004




Thanks for the help

[MattB]

No worries mate. My fee is £250 per message. I accept cheques and credit cards.

[andyc209]

[CB]

Lets just hope you don't have a French/ Italian/ American/ Chinese/ Russian built computer then!

[CB]