Hello!
I've been searching and searching for an answer, so hopefully, somebody
can provide a little help! [Smile]
I have a database with three tables and their fields (made nice and
simple):
tblMain: ID, DateEntered
tblSub1: SubID, ID, Title
tblSub2: SubID, ID, Title
ID is what binds tblMain to tblSub1 and tblMain to tblSub2 (there IS a
reason there are two "sub" tables, it's just made easy for this
example)
I want to display tblSub1 and tblSub2 in a DataGrid in order by their
DateEntered, which is in tblMain. I know how to use INNER JOIN for one
table, but in this case, we have two tables (the 'subs') being linked
to one (main).
Any help would GREATLY be appreciated!