Hmm... I've never used this before. I'll try it.
Thanks for your help and your quick reply!
--
Matthew Nuzum
www.bearfruit.org
cobalt@bearfruit.org
> Fortunately we have the set functions, specifically UNION ALL in this
> case.
>
> Maybe something like (minus the number of files/empty part):
>
> CREATE VIEW viewname AS
> SELECT fileid, filename, folderid, dsply_order FROM files
> UNION ALL
> SELECT folderid, foldername, parentid, dsply_order FROM folders;
>
> SELECT * from viewname where folderid=23 order by dsply_order;