You need to sign in to do that
Don't have an account?
VinH
Complex SOQL querys (with Joins), using ASP.NET 2.0
Hello,
I need to get data from a bunch of sforce tables that have fields that reference other tables.
I've read that Joins are not supported.
How can I do this using SOQL? I am programming in Visual Studio '05 using VB
-thanx
V
Cheers
Can you suggest how I can Join on the client?
- thanx
You put those into a datatable in the same dataset. You can now create a relationship for the two datatables specifing which field on the account datatable is the foriegn key (Id) and which field in the contact datatable that is the primary key (accountid).
The two should now be related and usable in databinding or whatever.
Cheers
Thanx Dave, I'll give that a try..
- V