Re: SQL Dummy Needs Help

* Cliff Crawford <cjc26@cornell.edu> menulis:
> 
> SELECT table2.title_no, table2.paidto_date
>     FROM table1, table2
>     WHERE table1.title_no=table2.title_no
>     AND (date_part('month', table1.effect_date) !=
>             date_part('month', table2.paidto_date)
>          OR date_part('day', table1.effect_date) !=
>             date_part('day', table2.paidto_date));

Ooops, I keep confusing C and SQL operators...the "!=" above should be "<>".


-- 
Cliff Crawford

He who sacrifices his conscience to ambition        burns a picture to obtain the ashes.  - Chinese proverb