public static DataTable GetforLookup(SQLITE_DAL SQLITE_DAL) { string q = " SELECT " + MASTERPATH.MASTERPATH_TBL + ".* \r\n"; q += ", " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_NAME + " \r\n"; q += " FROM " + MASTERPATH.MASTERPATH_TBL + " \r\n"; q += " INNER JOIN " + MASTERTABLES.MASTERTABLES_TBL + " \r\n"; q += " ON( " + MASTERPATH.MASTERPATH_TBL + "." + MASTERTABLES.MASTERTABLES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_ID + ")\r\n"; q += " WHERE " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.ACTIVE_ID + " = '" + Core.Active + "' \r\n"; q += " ORDER BY " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.MASTERPATH_ID + ";\r\n"; return(SQLITE_DAL.Listdata(q)); }