We help IT Professionals succeed at work.

Join 2 lists in SharePoint 2007

LessIsMore
LessIsMore used Ask the Experts™
on
I have 2 lists.
Locations table has fields Location and ID
Inventory table has fields Location (look up from Locations), Date, Inventory, etc.

I need to create report which locations DID NOT submit inventory to the end of the month.
Is it possible to do in SharePoint Designer and how?
I can link two lists in one DataView but do not know how to do Left join there.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
CAML - in a word
http://www.u2u.be/Tools/SharePointCamlQueryBuilder.aspx

You can install this feature, use the stand alone CAML query editor or learn enough CAML to type the query directly into your code

Author

Commented:
The administration of the SharePoint farm does not allow to install any of 3rd party solutions.
QPR

Commented:
Then do it by hand, learning from the resources on that site.
The CAML builder just makes it easier but only in a graphical sense

Author

Commented:
QPR,
I've moved to SQL view since SharePoint designer does not give me a solution. I thought somebody can suggest quick decision since my report is due yesterday.
On the site you suggested there is no free resources.
I though you cannot push your product here.
Thanks anyway
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.