Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-24 : 18:35:24
|
Zach writes "Dear SQL Master,
I have posted this question to no avail at sqlteam.com, and perhaps there is no answer. However, I have a conditional sql statement that selects one field from a table. Currently I call one of the sql statements, and then based on its result, call another. I understand that I can put this in a com object or stored procedure, however I would like to stay Access compliant so a stored procedure is out of the question.
My question is, can you have a conditional select in one sql statement?
select sequence from table where *sql statement* or *sql statement*
thanks
Zach
SQL Server 7.0 - NT 4.0 sp3or4 iis 4.0"
|
|
|
|
|
|
two select statements in one that grab one field