Sorting by key in related table.

[prev] [thread] [next] [Date index for 2005/04/24]

Hello,

I now sure how to do this and maybe someone here can help.

I the actual database there are five tables but only want to deal with 
two in this example.

I have a table called IssuedKey that is a linking table. I looks 
something like:

IssuedKey:
	id
	person_id
	auth_id
	building_id
	issued_date

I want to create a report of the people, who authorized, what building, 
and when they got the key, but I want to order by lname in the person 
table.

	Person:
		id
		fname
		lname
		status

And to add more confusion, I want to use Class::DBI::Plugin::Pager to 
divide the results by pages.

Can someone point me in the right direction.

Thanks,
Robert Boone