quinta-feira, 26 de abril de 2007

bater no fundo

USE AdventureWorks
SELECT HumanResources.Employee.Title,
Person.Contact.FirstName,
Person.Contact.LastName,
Person.Contact.Phone,
HumanResources.Employee.BirthDate
FROM HumanResources.Employee, Person.Contact
WHERE HumanResources.Employee.ContactID = Person.Contact.ContactID
AND HumanResources.Employee.MaritalStatus = 'S'
AND HumanResources.Employee.Gender = 'F'
AND HumanResources.Employee.BirthDate > '01-01-1980'
ORDER BY HumanResources.Employee.BirthDate DESC;

2 comentários:

Anónimo disse...

À procura de uma alma gémea??

jms disse...

hahahahahahaha que sacana! base de dados de pitinhas frescas com apenas um query.