Hello everybody, I have little question how to get record nuber? In example:
select t.* from (select recno,* from Simpsons) t where t.lastname like "B%"
In case of filtering I would like to get number in sub-query, not that one after filtration. I have an idea useing functions and random argument value, but it looks strange... If anyone has better idea... Please let me know.
-- Regards Michal Zaborowski (TeXXaS) http://sqlite4delphi.sourceforge.net/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]