SELECT physician ,  department FROM affiliated_with WHERE primaryaffiliation  =  1
What are each physician's employee id and department id primarily affiliated.
SELECT physician , department FROM affiliated_with WHERE primaryaffiliation = 1
select physician , department from affiliated_with where primaryaffiliation = value
What are each physician 's employee id and department id primarily affiliated .