| From: | Cliff Crawford <cjc26(at)cornell(dot)edu> |
|---|---|
| To: | Alder <Terrence(dot)Branscombe(at)gems8(dot)gov(dot)bc(dot)ca> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: SQL Dummy Needs Help |
| Date: | 2001-03-13 03:49:12 |
| Message-ID: | 20010312224912.A17508@cornell.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
* Cliff Crawford <cjc26(at)cornell(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-03-13 04:20:55 | Re: error joining 2 views containing GROUP BYs |
| Previous Message | Stephan Szabo | 2001-03-13 02:41:05 | Re: How does this query work.....? |