how to write sql query

[smitha mano]

--------------------------------------------------------------------------------
Emp.table

id name Desig
1 aaaa SA
2 bbbb PL



Address.table

id street CITY
1 Pulluvazhy Perumbavoor
2 Kizhillam Pulluvazhi



i wanted to retriev data

Desig =PL the city=pulluvazhi

[David Ulicny]

select e.id,e.name,e.desig from emp e where e.desig='PL'

for table address table it will be the same