Edit SQL, Help Needed!!!!!

[zaq888]

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 make adjustment on the sql above n combined the sql so it can show only data from date given by user?

 

[DanChard]

This would probably do it:

SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN TData ON TUnit.[cs-username]=TData.[cs-username]
WHERE TData.[cs-username] Is Null
and (Tdata.date BETWEEN ? AND ?)
ORDER BY date;

 

[zaq888]

no data is displayed... something wrong i think

what i ant to do is,
first select data from TUnit that range BETWEEN ? AND ?
This is the SQL command:

SELECT date, time, cs-username FROM TData WHERE (date BETWEEN ? AND ?) ORDER BY date

then from the result copy it to temp folder and from there do another sql satement like this:

SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN TData ON TUnit.[cs-username]=TData.[cs-username]
WHERE TData.[cs-username] Is Null;

but i don't know how to copy the first sql result to temp table/// anybody can help mee???



I'm Keep Studying.... please show the way...
Not Good in English