General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>property.key is unique.
>
>If it's unique why do you group on it? Also, what do you need exp_tick in the query for?
>
I need a table of unique properties that have outstanding or expired ticklers (they have an overdue task). exp_tick is all outstanding records from the tickler table. There could be multiple oustanding ticklers per property.key. so when i join exp_tick and property1, there are duplicate property.key in the resulting table. want to end up with properties that have outstanding ticklers, but the property.key is unique.
pre.select b.* ;
from (exp_tick) a, property1 b ;
where (b.key = a.key) ;
into table (exp_prop);
group by b.key ;
order by b.key
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only