select distinct u.URL_Address, u.URL_Name, u.URL_Summary, u.URL_ID, u.URL_Home, u.URL_Site
from URLs u, MyURLs m
where u.URL_ID = m.URL_ID
AND m.Emp_ID = 1
ORDER BY u.URL_Name
select distinct Pref_Color1
from PREFERENCES
where Emp_ID = 1
MISI Usability Portal: Links
useit.com: Growing a Business Website: Fix the Basics First For those of you who may find yourself doing an Expert Review in the future, this provides a few good design guidelines, for the rest of you, there is some good information on what to prioritize when designing a website or portal.