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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2004-09-02 : 15:48:30
|
| Any SQL Server people out there with INFORMIX experience...I think this is the next that will be dumped on me....Brett8-) |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-09-03 : 00:01:21
|
| I worked with informix for a couple of months a few years back.From what I can remember (which isn't much) you couldn't use JOIN, all the tables in the query had to be introduced in the from clause and joined in the where clause, if you wanted to use an outer join it had to be introduced as from table_a outer(or something like that) - therefore what us sql server people know as a left outer join is the only outer join available, but I am not even close to being able to even understand what a informix guru is - so don't take my word for it.There are however many people at our shop with very strong informix skills and yes - they still are using it.Maybe I should introduce them to this forum as some of their upcoming projects are gonna be on sql server.Duane. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Informix