in reply to Re^2: Re-indexing a SQL resultset by id
in thread Re-indexing a SQL resultset by id
SELECT * FROM student_classes;
Will you get several instances of each id? Yes?
Yes, but these fields are not called 'id'; here, it's just a suffix. A join, however, could result in multiple rows of the result set with the same id, even in a nice database design, so I do retract my observation about the database perhaps not being well-designed.
Juerd
|
---|
In Section
Seekers of Perl Wisdom