423,682 Members | 1,649 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,682 IT Pros & Developers. It's quick & easy.

Display data in one form from 2 different tables

P: 31
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. =)
Nov 27 '12 #1

✓ answered by 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.

Share this Question
Share on Google+
7 Replies


Rabbit
Expert Mod 10K+
P: 12,272
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.
Nov 27 '12 #2

P: 31
OK, thank you Rabbit. I will try search for it :)
Nov 27 '12 #3

solutionwand
P: 16
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
Dec 20 '12 #4

P: 31
Hi solutionwand,
Thank you for your reply =)
I have managed to solve that problem.
Dec 20 '12 #5

P: 3
Yes look up joins inner or outer.
Dec 20 '12 #6

P: 31
Thank you gumpagoo =)
Dec 24 '12 #7

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


in CommandText
Dec 25 '12 #8

Post your reply

Sign in to post your reply or Sign up for a free account.