I am trying to write a sql query in excel with a union clause and date parameters as below:
SELECT
user.desc,
user.name,
user.dob,
app.appointdate
from
user.usereeid=app.appointid
where app.appointdate Between ? And ?
Union
SELECT
user.desc,
user.name,
user.dob,
user.datecleared
from
employee
WHERE user.datecleared Between ? And ?
I have written this query in Connection Properties > Definition > Command text.this query works when i don't add the last parameter line WHERE user.datecleared Between ? And ? .How can i let it work this query for both parameter?
SELECT
user.desc,
user.name,
user.dob,
app.appointdate
from
user.usereeid=app.appointid
where app.appointdate Between ? And ?
Union
SELECT
user.desc,
user.name,
user.dob,
user.datecleared
from
employee
WHERE user.datecleared Between ? And ?
I have written this query in Connection Properties > Definition > Command text.this query works when i don't add the last parameter line WHERE user.datecleared Between ? And ? .How can i let it work this query for both parameter?