i'm using dataenvironment from vb to generate the sql query. my problem is i'm passing a date value from the datepicker.value and send it to the sql.
SELECT date, time FROM TData WHERE (date BETWEEN ? AND ?) ORDER BY date
? will read data from start.value and end.value(datepicker)
this is one more SQL statemant:
SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN TData ON TUnit.[cs-username]=TData.[cs-username]
WHERE TData.[cs-username] Is Null;
question: how can i join the two queries?
SELECT date, time FROM TData WHERE (date BETWEEN ? AND ?) ORDER BY date
? will read data from start.value and end.value(datepicker)
this is one more SQL statemant:
SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN TData ON TUnit.[cs-username]=TData.[cs-username]
WHERE TData.[cs-username] Is Null;
question: how can i join the two queries?