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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Display results of 3 rows in just 1
I have a table with canc_code1 canc_code2 canc_code3. These are cancellation reasons. There is a cancel codes table and a m_cancellations table. cancel code TABLE canc_code canc_desc 01 did not want 02 i do not have money m_cancellations TABLE contract canc_code1 canc_code2 canc_code3 10000...- cymerman
- Thread
- Replies: 2
- Forum: Informix solutions
-
Select info from all databases
Hi All, I have an old version of informix. I do have 8 different databases in the same system. The table structure is all the same across the system. How do I select info from one particular table in all the different databases ? I know that in SQL Server you can do something like: SELECT *...- cymerman
- Thread
- Replies: 1
- Forum: Informix solutions
-
how do I select the last 5 rows in informix
How do I select the last 5 rows of a table ? I have to use "order by" I guess. If this is not possible. How do I select just 5 rows (any rows) of that table ?- cymerman
- Thread
- Replies: 1
- Forum: Informix solutions
-
SELECT last 5 rows of a table
How do I select the last 5 rows of a table ? I have to use "order by" I guess. select * from tablename order by col1 asce where last 5 THANKS -
How do I delete the results of a query
Hi All, I have run a query and exported the results from that query to a TXT file. 2503 Rows. Is there any way to write a statement that delets everything that is on this TXT file ? I know the other way which is using the delete blablabla from table where blablabla. But was just wondering if... -
What am I doing wrong
Hello ALL, I want to list every client # that is in the clients table but is not in the contracts table. The purpose is to bring all clients that do not have any contract attached to it and clean the clients table. clients client_no surname firstname 1 john smith 2...
