This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:features:segments:querying [2012/03/05 21:39] doc |
admin:features:segments:querying [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 27: | Line 27: | ||
| >> from INDIVIDUALS | >> from INDIVIDUALS | ||
| >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | ||
| - | >> where INDIVIDUAL in (segment(PART_1), segment(PART_2)) and | + | >> where INDIVIDUAL in ($segment(PART_1), $segment(PART_2)) and |
| - | >> INDIVIDUAL = segment(PART_3); | + | >> INDIVIDUAL = $segment(PART_3); |
| INDIVIDUAL BIRTHDATE CITY ST | INDIVIDUAL BIRTHDATE CITY ST | ||
| Line 40: | Line 40: | ||
| 000403467441 2003-04-19 PHOENIX AZ | 000403467441 2003-04-19 PHOENIX AZ | ||
| 000403467440 1997-02-28 PHOENIX AZ | 000403467440 1997-02-28 PHOENIX AZ | ||
| - | 000403490448 1988-07-03 PHOENIX AZ | ||
| - | 000403490440 1988-04-14 PHOENIX AZ | ||
| - | 000800138400 1980-06-17 DENVER CO | ||
| 000800345452 1998-08-31 DENVER CO | 000800345452 1998-08-31 DENVER CO | ||
| 000800345453 2003-12-25 DENVER CO | 000800345453 2003-12-25 DENVER CO | ||
| - | 000800345451 1982-07-08 DENVER CO | ||
| - | 000801610625 1985-10-21 DENVER CO | ||
| 000801610627 2004-03-17 DENVER CO | 000801610627 2004-03-17 DENVER CO | ||
| 000802420583 1990-03-18 DENVER CO | 000802420583 1990-03-18 DENVER CO | ||
| - | 000802420582 1987-06-16 DENVER CO | ||
| 000802420584 1993-10-06 DENVER CO | 000802420584 1993-10-06 DENVER CO | ||
| 000803400688 1990-06-16 DENVER CO | 000803400688 1990-06-16 DENVER CO | ||
| Line 57: | Line 51: | ||
| 000803760387 1997-09-24 DENVER CO | 000803760387 1997-09-24 DENVER CO | ||
| - | 24 rows returned | + | 18 rows returned |
| </code> | </code> | ||