Pull the data into a view and index it accordingly.

>Well, consider this.
>
>I'm trying to populate a list:
>
>

>Client    Address      City    State   Zip   Phone   Email
>-----------------------------------------------------------
>

>
>When the user clicks on a header, the list will sort accordingly.
>The problem is that the data is in 4 separate tables.
>
>One client, many addresses, phones and emails.
>
>Ideas?
>
>