Re: using variables in select statements

[pearsojd]

Hi,

Am not sure what your example is demonstrating, but here is a different example of assigning and using variables (`exam` is an attribute);

select @exam_student1 := exam from student where student_id ='1'

this should return a result set. Then you can use the variable e.g;

select * from student where exam > @exam_student1;

Hope this helps.

James.