On Fri, Mar 09, 2001 at 11:05:38AM -0800, Alder wrote:
> I'm pretty new to SQL and can't figure out how to write what should be a
> simple query of two tables. Could someone here possibly help me out?
>
> Table 1 has two fields I'm interested in: TITLE_NO and EFFECT_DATE
> Table 2 also has two f
* Cliff Crawford <[EMAIL PROTECTED]> 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
* Alder <[EMAIL PROTECTED]> menulis:
> I'm pretty new to SQL and can't figure out how to write what should be a
> simple query of two tables. Could someone here possibly help me out?
>
> Table 1 has two fields I'm interested in: TITLE_NO and EFFECT_DATE
> Table 2 also has two fields of interest:
Well, you should probably get yourself a good SQL book :) but here's a try
(untested). How about something like:
SELECT DISTINCT title_no, paidto_date
FROMtable1, table2
WHERE table1.title_no = table2.title_no
AND table1.effect_date <> table2.paidto_date;
Again
I'm pretty new to SQL and can't figure out how to write what should be a
simple query of two tables. Could someone here possibly help me out?
Table 1 has two fields I'm interested in: TITLE_NO and EFFECT_DATE
Table 2 also has two fields of interest:TITLE_NO and PAIDTO_DATE
TITLE_NO is uniqu
