Re: [SQL] Re: [GENERAL] Getting the result of a query using COUNT(*)

2000-08-28 Thread Alexandru COSTIN
Hello Try this way: SELECT COUNT(*) as no FROM MyTable rs.getint("no"); Or SELECT COUNT(*) FROM MyTable rs.getInt(0); (or (1)) alexander > Jackson Ching wrote: > > > > Hi, > > > > I'm using JSDK 2.0 and IBM JDK 1.3 on Red

Re: [SQL] Outer join statement ?

2000-08-31 Thread Alexandru COSTIN
Hello, There are 2 ways of doing outer joins, both are relatively expensive from the CPU time point of view 1. Create a function that returns the ojined value, or null if the value does not exists in the secod table 2. Use a union beetwen a left join and a straight select with a wh