PDA

View Full Version : sql query

caustin0
05-03-02, 18:07
Is it possible to combine an if statement with sql...example:

if x=y then
SELECT *
FROM tbl_comp
else
SELECT *
FROM tbl_comp
Where x<>y
alligatorsql.com
05-03-02, 18:11
Hello,

in which context. In PL/SQL on Oracle ... in general ... on MS SQL Server ... ????

Regards
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com
caustin0
05-06-02, 10:15
It is actually MS Access 97, in the QBE Grid.
Bolti
06-21-02, 06:50
I would not think it suports any PL/SQL at all :confused:
jaydog96
06-21-02, 17:49
What you need cannot be accomplished in the QBE grid, but you can write a code module that will allow you to do what you need. Check the help and take a look at the SELECT CASE command.

Hope it helps,
j-Dog