I have two tables in my dataset (well, more but for the purpose of my
question let's just say two). TableA has a int32 in it that refers to
the ID of a TableB row, many rows in TableA refrence just a few rows
that exist in TableB. I'd like to select all rows in TableA and sort by
TableB.SortID (SortID is a column in TableB). My tables are setup like
this (once again, not really but just for the sake of this question):
(TableA)
[ID(int32)][TableBID(int32)]
(TableB)
[ID(int32)][SortID(int32)]
This is a simple query in SQL, however I can't figure out how to phrase
my TableA.Select("","SORT") in order to get the information i need.
Any help would be great,
--
Benny Raymond
http://bloatedcowsoftware.com