Display data in one form from 2 different tables

[huda89]

Hi,
I would like to ask, is it possible if i would like to display data in one form from two different table in database? Thank you. =)

[Rabbit]

Yes it is. You just need to write your query as a join query or a union query. How you write your query depends on how those two tables are related, you were unclear in that aspect.

[huda89]

OK, thank you Rabbit. I will try search for it :)

[solutionwand]

Hi,

yes, please study joins in detail.
http://www.w3schools.com/sql/sql_join.asp
You will understand the whole concept, you can join any number of tables together

[huda89]

Hi solutionwand,
Thank you for your reply =)
I have managed to solve that problem.

[gumpagoo]

Yes look up joins inner or outer.

[huda89]

Thank you gumpagoo =)

[HosseinKhoddami]

You can Write
Select Table1.a , Table2.b
From Table1 Inner join Table2
on Table1.Fieldn = Table2.Fieldn


in CommandText