Sorting a query with joined tables

[joatmofn]

My query includes 3 tables, tblWorkorders, tblCustomers, tblProperties. The tblCustomers and tblProperties are joined to tblWorkorders via an ID field, e.g., tblCustomers.ID joined to tblWorkOrders.customerID.

Further, tblWorkOrders.customerId is a lookup field, as is tblProperties.propertyId.

My query only needs fields from tblWorkOrders. However, I included tblCustomers, and tblProperties so that I could sort the query by tblCustomers.customername and tblProperties.propertyname.

Without the inclusion of these two tables, sorting the query by tblWorkOrder.customerid and tblWorkOrder.propertyid merely sort by the value contained in those fields which is long int.

I need to remove the additional tables, but still need to sort by propertyname and customername. Is there a way to do that without including the other two tables?

Thanks.

 

[lespaul]

Uncheck the 'Show' box in the grid and it should sort by your two fields, but not show them in the results.

Leslie

 

[joatmofn]

Nope, that won't work. Doing so removes the columns from the query results.

 

[r937]

> "I need to remove the additional tables, but
> still need to sort by propertyname and customername."

cannot be done if you remove the tables from the query

rudy

http://r937.com/

SQL Consulting

 

[lespaul]

What is your SQL? What results does it show, what results do you want it to show?

 

[joatmofn]

That's what I thought. Thanks.