its just eaiser to use a join between the two tables. unless you have a
really good reason not to. it will probably be a bit quicker too depending
on your indexes.

regards
martin.

At 12:01 PM 10/20/2003 -0400, you wrote:

>Is this ok?
>
>SELECT MyRec, MyRec1 FROM MyRecTable WHERE MyDateField IN
> (SELECT OtherDate FROM OtherTable WHERE
> (OtherDate >= '1/1/2003 00:00:00')
> AND
> (OtherDate <= '12/31/2003 00:00:00'))
> ORDER BY
> MyDateField
>
>Or should I use a Join if possible?
>
>Thanks,
>
>Lee
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003


[Non-text portions of this message have been removed]