Comments on SharePointBlue - Yet Another SharePoint Blog: Join Lists Using SharePoint Designer 2007

Not really.

2014-01-28T12:16:06.443-05:00

Not really.

hello is it possible to view the data in a datashe...

2014-01-28T10:03:41.820-05:00

hello is it possible to view the data in a datasheet view.?

thanks for your help ... helps me a lot!

2013-02-15T05:11:00.713-05:00

thanks for your help ... helps me a lot!

SharePoint Lists dont support SQL. However LinQ an...

2012-07-17T09:41:52.268-04:00

SharePoint Lists dont support SQL. However LinQ and CAML Queries in C# could achieve this. But I have written exact same post for SharePoint 2010 version.

URL: http://mysplist.blogspot.com/2012/07/sharepoint-2010-join-two-lists-child.html

A while back we tried to do something similar in S...

2012-07-17T07:25:01.779-04:00

A while back we tried to do something similar in SP2010 but going the other way. The above example is essentially trying to view the parent from the child, which department is a student in. We were looking to do the equivalent of which students are in a department. Never really got it to work. Not the first time, as a former DBA, I've wanted to be able to tell sharepoint to let me treat lists like DB tables and just write a SQL query.

Something does not look right with your SPD. Only ...

2012-06-06T09:38:20.201-04:00

Something does not look right with your SPD. Only thing I can think of is, to make sure you have the Service Pack 2 installed for SPD 2007.

Hi Taher, Many Thanks For your post which is looki...

2012-06-06T07:10:06.844-04:00

Hi Taher, Many Thanks For your post which is looking great, but i tried to follow each step on the article but it didn't work fine with Once i working with step 8 "In Join Subview dialog, select Department_x0020_ID = ID and hit OK" ... popup that's appear with no fields..!!?? any help please

I dont think that is possible, I am assuming that ...

2012-02-28T09:06:08.228-05:00

I dont think that is possible, I am assuming that two lists will have different schema.

Can I join two lists but put the resultant data in...

2012-02-28T08:33:11.875-05:00

Can I join two lists but put the resultant data into one of the 2 lists?

Thank you for verifying it :).

2012-01-05T10:00:52.930-05:00

Thank you for verifying it :).

It's done! The key is to do the same steps bu...

2011-12-20T17:43:10.358-05:00

It's done!

The key is to do the same steps but in the internal table. I followed the same steps for link Student-Department, then in the internal table just created, I have to repeat the step 6 and forward for link Deparment-Area. :)

You can use the same above technique however you h...

2011-12-20T15:16:35.287-05:00

You can use the same above technique however you have to deal hard with the HTML formatting.

How could it do a Data View with 3 list, like: * S...

2011-12-19T15:30:06.725-05:00

How could it do a Data View with 3 list, like:
* Student (ID, Department_x0020_ID, Title)
* Department (ID, Title, Area_x0020_ID, Title)
* Area (ID, Title)
I need to show the join between them.
Is it possible do that (a two level join based on the ID like step 8)?
The query should be STUDENT > DEPARTMENT > AREA.

I tried but the results I've got were:
Student | Department | Area
A | D1 | A1
B | D1 | A1
C | D2 | A1
When D1 has A1 and D2 has no Area. So the right view should be:
Student | Department | Area
A | D1 | A1
B | D1 | A1
C | D2 |

Thanks.

Nope. It can be list columns too.

2011-10-14T07:41:03.491-04:00

Nope. It can be list columns too.

Do the joined columns need to be "site" ...

2011-10-14T06:37:36.429-04:00

Do the joined columns need to be "site" columns?

I haven't tried in SPD 2010 but this concept/t...

2011-08-10T10:31:56.815-04:00

I haven't tried in SPD 2010 but this concept/technique should be the same.

how to do the same in SharePoint 2010. Any idea pl...

2011-08-09T21:05:53.091-04:00

how to do the same in SharePoint 2010. Any idea pl share it

Regular lookup is based on the lookup Column which...

2010-06-24T11:39:46.968-04:00

Regular lookup is based on the lookup Column which can have multiple entries of same name :o)(unless you specifically apply some rule).

And we know every list has IDs so use one list's ID in other list to make a child parent relationship and above technique to display the records.

Pardon my (extreme) ignorance, but how is this dif...

2010-06-17T14:52:29.273-04:00

Pardon my (extreme) ignorance, but how is this different from creating a regular lookup?