need a view with "order by"

[James Johnson]

I have 2 tables and am displaying data in a single table on a web page
from both tables. Most of the data that I'm displaying is in table 2 but
some is in table 1 (lastname, firstname). I'm using "order by" to allow
sorting table 2 using hyperlinks, but I haven't figured out how to allow
sorting the "view" based on the lastname/firstname from table 1. The 2
tables are linked by a primary key. "Client_id" is a primary key in
table 1 and is a foreign key in table 2.

Is there a way to sort a view of 2 tables? I'd like to be able to sort
on lastnames from table 1 and then have the view show the correct data
from table 2 (get table 2 to display by last name).

thanks,
Jim

[Bill Karwin]

James Johnson wrote:

Is there a way to sort a view of 2 tables? I'd like to be able to sort
on lastnames from table 1 and then have the view show the correct data
from table 2 (get table 2 to display by last name).

Does this do what you want?

SELECT table2.*
FROM table1 INNER JOIN table2 USING (Client_id)
ORDER BY table1.lastname, table1.firstname

Regards,
Bill K.

[James Johnson]

On Tue, 04 Jan 2005 12:13:25 -0800, Bill Karwin <bi**@karwin.com> wrote:

James Johnson wrote:

Is there a way to sort a view of 2 tables? I'd like to be able to sort
on lastnames from table 1 and then have the view show the correct data
from table 2 (get table 2 to display by last name).

Does this do what you want?

SELECT table2.*
FROM table1 INNER JOIN table2 USING (Client_id)
ORDER BY table1.lastname, table1.firstname

Regards,
Bill K.

Thanks for your suggestion. That works perfectly.

Jim