April 16, 2013 at 1:07 pm
Hi friends,
I ave 3 tables-
1) JP,
2) WO,
the JP and WO are rellated by column : JP ID
Now the problem Im facing is that a JP can have mutiple WOs example-
JP1234 , WO67,WO69 and each WO has a revision # - say REV#1, and REV#2 and per my business requirement I want to get the WO with the highest REV# FROM JP -when I join these tables but that is not happening-
below is the Left Inner Join I'm using-
--
FROM JP
-join on [WO] with [JP]
left outer join [WorkForce_WorkOrder]
on [JP].[JP_ID] = [WO].[JP_JP]
THANKS
dHANANJAY
April 16, 2013 at 1:14 pm
Sorry, but there really isn't anything in your post with which to work with here. We can't see what you see.
Pleasse read the first article I reference below in my signature block. It will walk you through what you need to post and how to post it to get the best possible answers quickly. In return for the extra work you do up front to help us help you, you get tested code in return.
April 16, 2013 at 2:01 pm
No worries Lynn i was able to resolve it.
Sorry I bothered you for this
thanks
DJ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply