So Clare, your sig....

[luso2kx]

Looking for a hot rich widow I see....

[Claremonster]

:D Who isn't?

[luso2kx]

:D Who isn't?And ones who are terminally ill?

(Personal note: I've been a Programmer/DBA for WAAAAAAAAAAY too long)

EDIT: Nevermind, whose parents are dead or dying.

[Claremonster]

And ones who are terminally ill?

(Personal note: I've been a Programmer/DBA for WAAAAAAAAAAY too long)

EDIT: Nevermind, whose parents are dead or dying.

Ah, but it's the inlaws who are either dead or dying ROFL

[luso2kx]

Ah, but it's the inlaws who are either dead or dying ROFLYou should go with my upgraded version.

SELECT TOP 1 w.[name] FROM dbo.women w
INNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_id
WHERE ((i.net_worth > 10000000)
AND (i.status IN ('deceased', 'dying'))
AND (w.husband_id IS NULL)
AND (w.iq > 'Fruit Fly' AND w. iq < 'Oprah Regular')
AND (w.tv_preferences NOT IN ('Sex in the City','Grey''s Anatomy')))
ORDER BY w.hotness_factor DESC

:D

[Claremonster]

You should go with my upgraded version.

SELECT TOP 1 w.[name] FROM dbo.women w
INNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_id
WHERE ((i.net_worth > 10000000)
AND (i.status IN ('deceased', 'dying'))
AND (w.husband_id IS NULL)
AND (w.iq > 'Fruit Fly' AND w. iq < 'Oprah Regular')
AND (w.tv_preferences NOT IN ('Sex in the City','Grey''s Anatomy')))
ORDER BY w.hotness_factor DESC

:D

I dont' allow my women to watch TV. I dont' let them read either. You let them do that, and the next thing you know, they're trying to think and stuff. That's dangerous.