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));
}
