I was wondering if there was any way to use the field "logon script" under user properties in XP to run a script to map a network drive (we don't run a domain). my boss (who knows little about pc's) insists on not having to click on the mapped drive and put a password in every time he logs on...
all that i get is 1000's of records of the same account which does exist in 2006 & 2007. my query (under show SQL) reads as
SELECT ALL IAS4.PARDAT.PARID, IAS4.PARDAT.TAXYR, PARDAT_A1.TAXYR
FROM IAS4.PARDAT, IAS4.PARDAT PARDAT_A1
WHERE (IAS4.PARDAT.TAXYR=2006
AND PARDAT_A1.TAXYR=2007
AND...
that didn't quite work. i have the relationship set but it doesn't give me the results that i need. i.e. our database consists of all properties in the county. every property has an "account" in every tax year. i'm trying get results for "accounts" that exist in tax year 2006 but not in tax...
trying to create a query in query builder and wondering if anyone knows anything about setting the table relationship. i am intersted the the part about "A not found in B" but the data doesn't seem to follow this relationship.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.