Subject order by on different way From Dirk <non@non.com> Date Mon, 15 Nov 2021 21:17:32 +0100 Newsgroups dbase.getting-started hello, i need some explanation about :order by     this is placed in open :  form.vraagbak_sort = form.vraagbak_firma.sql    local cSort          cSort = Form.vraagbak_firma        //form.vraagbak_sort = form.vraagbak_firma.sql        // form.Veld_zoek_data.value = ""        form.Veld_zoek_data.setfocus()       Do Case        case this.value == "firma"         cSort.active = false                        cSort.sql = form.vraagbak_sort+[order by name]                         cSort.active = true               cSort.rowset.first()   1 ) when i create a query with a join between  firma data and contact   data  i can order by name or whatever   2)  when i use 2 queries and conected with masterfields ..       get message invalid use of keyword By    the form is used to create data some info would be helpfull regards Dirk,