he first--and most
offbeat--solution, because I was looking for a one-SQL-statement solution.
Hope this helps.
- Original Message -
From: Brian Smith
To: Bill Easton
Sent: Saturday, March 02, 2002 8:51 AM
Subject: RE: help me with complicate sql query
I guess this would work if per
| mn |
+---++--+
| 1 | unassigned | NULL |
| 3 | in org 2 |1 |
+---++--+
2 rows in set (0.00 sec)
> From: "Brian Smith" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: help me wi
Hello sql guru's, I need help find SQL to solve a problem:
I have two tables, the first is persons:
person_id int unsigned not null auto_increment
firstname varchar(25)
lastname varchar(25)
The second is person_orgs
person_id int unsigned not null
org_id int unsigned not null
A person may be
