Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ShockValue
- Order by date
-
subquery in a query using a case
I have to code this to work across 7.9 2000i to version 10 [Pervasive][ODBC Engine Interface]Syntax Error: select<< ??? >>>>>>>>>>>>>>>>>>>>>>>>- ShockValue
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
subquery in a query using a case
I am trying to do with pervasive sql somehting like this, basically if it a nested subquery in a case. I can do this in MSSQL but pervasive is trickier. select "Date","FNAME","LASTNAME","ID",select case "ID when 10 then (select "altid" from "system") else "ID" end select as "DAYID" from "Account"- ShockValue
- Thread
- Replies: 2
- Forum: Pervasive: Pervasive.SQL
