question about retrieving

[johland]

Hi I have 2 tables: 1. Physicians, consisting on two columns: primery_specialty_id, sub_specialty_id 2. Specialties, consisting on two columns: specialty_id (primary key and the foreign key for both Physicians table columns above), specialty_name Physicians.primery_specialty_id is nn but sub_specialty_id can be null and in my db there are a lot of physicians that have 1 specialty but not a second. I want to create a view that will retrieve all data showing the specialty_name1 for all primery_specialty_id and specialty_name2 for all sub_specialty_id. I try to create another view that will hold the specialty_name for the sub_specialty but I don’t know how can I show all data containing the sub_specialty which is null. if anyone can help me on this it will be more than appreciated Thanks Yohay