Redhot <tnol...@ymail.com> wrote:
> I would like select a date range (from/To) from a date database selection.
> The user enters a date (ProcessDate) in the database. ProcessDate is stored
> in table (tblData). I would like to get from another table (TblFund) the
> Rows that match the data criteria based on Date (ProcessDate)entered in the
> table (tblData).
Read about joins in your favorite SQL textbook.
Does tblData table have only one row?
> Here is what I'm trying to do:
> I'm tryng to Select from tblfund, column fund_type where Column fund_type
> equals Car_Fund and the fundDate is between ProcessDate and EndDate. This
> selection is based on the date entered by the user which is the ProcessDate
> staored in another table.
select * from tblFund, tblData where
fund_type='Car_Fund' and
fundDate between ProcessDate and date(ProcessDate, '+6 months');
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
