0

Guys,

I have records from table 1. the objective is to get the
date from Table 2. when i try to use select statement to obtain the records
it pull all itemnumber with the same item number in TABLE 2. is there any idea to to this using the result below. thanks.

TABLE 1	
ItemNumber	Ponumber
P300-1110-C731-U	8933867
P300-1110-C731-U	8933867
P300-1110-C731-U	8402605


TABLE 2		
PONumber	ItemNumber	Date
9095105	P300-1110-C731-U	8/31/2011
9095105	P300-1110-C731-U	8/31/2011
9095105	P300-1110-C731-U	8/31/2011
9095105	P300-1110-C731-U	8/31/2011
8402605	P300-1110-C731-U	3/31/2011
8402605	P300-1110-C731-U	3/31/2011
8402605	P300-1110-C731-U	3/31/2011
8402605	P300-1110-C731-U	3/31/2011
8402605	P300-1110-C731-U	3/31/2011
8402605	P300-1110-C731-U	3/31/2011
8933867	P300-1110-C731-U	7/30/2011
8933867	P300-1110-C731-U	7/30/2011
8933867	P300-1110-C731-U	7/30/2011
8933867	P300-1110-C731-U	7/30/2011


RESULT:		
ItemNumber	Ponumber	Date
P300-1110-C731	8933867	7/30/2011
P300-1110-C731	8933867	7/30/2011
P300-1110-C731	8402605	3/31/2011

Regards,

JOV

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by jovillanuev
0

You need to join both the tables based on ItemNumber or Ponumber or both based on your database structure.

0

Thanks for your reply.

I used sub query.

(Select max(date) from table2 as t2 where t1.itemnumber =t2.itemnumber
and t1.ponumber = t2.ponumber) as pomonth

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.