471,350 Members | 1,798 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

Sorting a dataset

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
Jan 20 '06 #1
0 865

This discussion thread is closed

Replies have been disabled for this discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.