Local SQL select for date=today
Posted on 2006-07-11
I'm trying to limit my extract from two tables to those records where ufsale = today
SELECT (trim(both " " from key1)+"/0 "+ g1.company) as receivercompany,
ulocname as locationname,
g1.zip as costcentre,
g1.contact as receiverattn,g1.phone1 as receiverph,
g1.city as address3
from Contact1 g1, contact2 g2
where g1.accountno =g2.accountno
Using Access or SQL Server this would work fine, but for Local SQL what is the syntax for where ufsale=today?
Urgent help required for a simple question, note it is "Local SQL" as in Paradox,xBase
All help is appreciated.