internal bool GetJoin(Join_for_SQLView_InDataBase join, ref Join_for_SQLView_InDataBase refJoin)
 {
     foreach (Join_for_SQLView_InDataBase j in items)
       {
       if (j.TableName.Equals(join.TableName))
       {
           refJoin = j;
           return true;
       }
       }
       return false;
 }
        private void GetJoins(Column.nullTYPE nulltype, SQLTable pParentTable, string PreAliasTableName, string pParentTable_alias_table_name)
        {
            string alias_table_name = PreAliasTableName + SQLTable.VIEW_TableName_SEPARATOR + this.TableName_Abbreviation;
            Join_for_SQLView_InDataBase join = new Join_for_SQLView_InDataBase(null, TableName,TableName_Abbreviation, alias_table_name, PreAliasTableName + "." + this.TableName + "_ID", alias_table_name + ".ID", nulltype);
            Join_for_SQLView_InDataBase RefJoin = null;
            join.tbl = this;
            pParentTable.jList.items.Add(join);

            foreach (Column col in Column)
            {
                if (!col.IsIdentity)
                {
                    if (col.fKey != null)
                    {
                        if (col.fKey.fTable != null)
                        {
                            col.fKey.fTable.GetJoins(col.nulltype, this, alias_table_name, PreAliasTableName);
                        }
                    }
                }
            }
        }