create view on two lists (join)

Hi,

I have two lists, in two different sites and would like to create a view,
which joins both on some sort of primary key.
How can I achieve this?

Regards
Karsten Grombach

anonymous
Fri Jan 30 06:01:06 CST 2004

definitely u need coding to join two list if u wanna a mixed view

b

te

----- Karsten Grombach wrote: ----

Hi

I have two lists, in two different sites and would like to create a view
which joins both on some sort of primary key
How can I achieve this

Regard
Karsten Grombac

Karsten
Fri Jan 30 06:30:17 CST 2004

what level of coding would be necessary? can i achieve this with caml ? or
do i need to write a web part or webapplication ?

regards
karsten


"tedteng" <anonymous@discussions.microsoft.com> wrote in message
news:3A3FD219-616F-4AC9-AA01-4A4674727ABF@microsoft.com...
> definitely u need coding to join two list if u wanna a mixed view.
>
> br
>
> ted
>
> ----- Karsten Grombach wrote: -----
>
> Hi,
>
> I have two lists, in two different sites and would like to create a
view,
> which joins both on some sort of primary key.
> How can I achieve this?
>
> Regards
> Karsten Grombach
>
>
>

anonymous
Fri Jan 30 06:56:07 CST 2004

I am not familar with CAML. But i believe a web part is ok, no need with an application. And u can import lists to arrays and then process them and then render the result to the web part.

br

ted



----- Karsten Grombach wrote: -----

what level of coding would be necessary? can i achieve this with caml ? or
do i need to write a web part or webapplication ?

regards
karsten


"tedteng" <anonymous@discussions.microsoft.com> wrote in message
news:3A3FD219-616F-4AC9-AA01-4A4674727ABF@microsoft.com...
> definitely u need coding to join two list if u wanna a mixed view.
>> br
>> ted
>> ----- Karsten Grombach wrote: -----
>> Hi,
>> I have two lists, in two different sites and would like to create a
view,
> which joins both on some sort of primary key.
> How can I achieve this?
>> Regards
> Karsten Grombach
>>>

anonymous
Fri Jan 30 07:16:09 CST 2004

Just correct my answer: u can export the lists to dataset then u can use sql to join them

sorry i cannot provide further advice

b

te

----- tedteng wrote: ----

I am not familar with CAML. But i believe a web part is ok, no need with an application. And u can import lists to arrays and then process them and then render the result to the web part

b

te



----- Karsten Grombach wrote: ----

what level of coding would be necessary? can i achieve this with caml ? o
do i need to write a web part or webapplication

regard
karste


"tedteng" <anonymous@discussions.microsoft.com> wrote in messag
news:3A3FD219-616F-4AC9-AA01-4A4674727ABF@microsoft.com..
> definitely u need coding to join two list if u wanna a mixed view
>> b
>> te
>> ----- Karsten Grombach wrote: ----
>> Hi
>> I have two lists, in two different sites and would like to create
view
> which joins both on some sort of primary key
> How can I achieve this
>> Regard
> Karsten Grombac
>>>

Karsten
Fri Jan 30 07:17:20 CST 2004

thanks ted!
karsten

"tedteng" <anonymous@discussions.microsoft.com> wrote in message
news:B4B1AEF4-3002-41D6-83E6-2BE5EBC8CD2D@microsoft.com...
> I am not familar with CAML. But i believe a web part is ok, no need with
an application. And u can import lists to arrays and then process them and
then render the result to the web part.
>
> br
>
> ted
>
>
>
> ----- Karsten Grombach wrote: -----
>
> what level of coding would be necessary? can i achieve this with caml
? or
> do i need to write a web part or webapplication ?
>
> regards
> karsten
>
>
> "tedteng" <anonymous@discussions.microsoft.com> wrote in message
> news:3A3FD219-616F-4AC9-AA01-4A4674727ABF@microsoft.com...
> > definitely u need coding to join two list if u wanna a mixed view.
> >> br
> >> ted
> >> ----- Karsten Grombach wrote: -----
> >> Hi,
> >> I have two lists, in two different sites and would like to
create a
> view,
> > which joins both on some sort of primary key.
> > How can I achieve this?
> >> Regards
> > Karsten Grombach
> >>>