SQL query help 1

[audiopro]

I need a query where the results are based on a total of three columns and then arranged in the total order.
MEKTOT is not recognised as an SQL column in the WHERE clause - Could someone suggest a way round it?

SELECT REC, INVNO, (INTOT+PICTOT+FREETOT) AS MEKTOT FROM FRAMES WHERE [red]MEKTOT[/red] > 100  ORDER BY MEKTOT

Keith

http://www.studiosoft.co.uk

 

[GriffMG]

Try

Select a,b,c, (a+b+c) as d from table1 where a+b+c > 100 order by d

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[audiopro]

That worked a treat - thanks very much

Keith

http://www.studiosoft.co.uk

 

[GriffMG]

Good luck
Thanks for the star!

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.