Pls explain the following Experts. Thank you.

Can someone explain to me these few Select statements. This is my first time seeing such a statement.

This is the First:

select * from vrptindlast where 1 =2

This don't come out anything when I put into SQL but I saw in The prorgam actually works. Maybe the '1' is assign as a variable column and '2' could be another variable that assigns the search value to compare. Could be lah.

This is the second:

SELECT [drawing project].jobno, inputdate, [drawing project].service, jobdes, requestdate, startdate, expcompleteddate, [drawing details].dwgno, dateinputamend, cadname, drawnby, drawndate, dwgscale, revision_issue, package_issue, subservice, dwgtitle, degcompletedate, proclosedate, maxdate, viewr1aa.tspercent

FROM [drawing details], [drawing project], viewr1aa

WHERE [drawing details].jobno = [drawing project].jobno and viewr1aa.dwgno = [drawing details].dwgno and 1=2

Also first time see such a statement. Didn't know you can do an IF statement like this. Oh yeah what if the condition is not meet? I guess it won't dislay that column right. Pls tell... I kinda have 1/2 a clue only.

This is the third:

What does '?' mean?

select * from view3 Where (s_code = ?)

This is found inside the VB6.0 DataEnvironment.

NHK