Query

Question

I want to get the data from two tables from one table i want to get all the data and from second table i want just one column i have a relationship between the tables 

 

SELECT * from First,S.CodeName

INNER JOIN second AS S on Second.RID=First.RId

 

 

1-one way is to get all the columns from first table by name to name like i have to include all the columns just like that

SELECT F.Name,F.Code,F.Date from First

INNER JOIN Second as S ON s.Code=F.Code

Oder by F.Code

 

 

---This works fine but i want to know other way how to used Select * and a specific column in one query please assists  

Answer 1

I don't want all time tab index disabled

Answer 2

set tabindex = -1 to all control..

Answer 3

Here is how. You can define IsTabStop property to false for the other controls and it should work for you.

<Buttonx:Name="button"Content="Button"HorizontalAlignment="Left"Margin="242,107,0,0"VerticalAlignment="Top"Width="75"TabIndex="1000000"IsTabStop="False"/>
<TextBoxx:Name="textBox"HorizontalAlignment="Left"Height="23"Margin="204,67,0,0"TextWrapping="Wrap"Text="TextBox"VerticalAlignment="Top"Width="120"TabIndex="0"/>