How to display two linked tables
Posted: Wed Jan 06, 2010 4:01 am
Hello!
I want to display recordset of two linked tables as one categorical list.
Table Structure:
Table1 (fieldkey1, field2)
Table2 (fieldkey1, field2, Table1fieldkey3)
SQL:
rsTable1 = Select * from Table1
rsTable2 = Select * from Table2
Expected Result:
Colors(Table1)
Blue(Table2)
Green
Red
Yellow
:
:
Fruits(Table1)
Apple(Table2)
Orange(Table2)
:
:
Please also suggest if the following SQL statement would be better and how to use it:
SELECT Table1.*, Table2.*
FROM Table1 INNER JOIN Table2 ON Table1.fieldkey1=Table2.table1fieldkey3
ORDER BY Table1.fieldkey1;
I want to display recordset of two linked tables as one categorical list.
Table Structure:
Table1 (fieldkey1, field2)
Table2 (fieldkey1, field2, Table1fieldkey3)
SQL:
rsTable1 = Select * from Table1
rsTable2 = Select * from Table2
Expected Result:
Colors(Table1)
Blue(Table2)
Green
Red
Yellow
:
:
Fruits(Table1)
Apple(Table2)
Orange(Table2)
:
:
Please also suggest if the following SQL statement would be better and how to use it:
SELECT Table1.*, Table2.*
FROM Table1 INNER JOIN Table2 ON Table1.fieldkey1=Table2.table1fieldkey3
ORDER BY Table1.fieldkey1;