quote:

---

Originally posted by pinoyextacy

I am new to sql sorry but I am more familiar with programming languages like C++. I am still trying to read up on it. Well, yesterday I got help from the forum and it was very helpful. I was going through a table and selecting the client_ref_no and clt_id to see if I had duplicates in the table and if I did to choose the duplicate that had the newest list_date. It went like this:

select clt_ref_no, clt_id, status_code, max(list_date) as max_list_date
from inventory
where clt_id in ('A', 'B', 'C') and status_code='paid'
group by clt_ref_no, clt_id, status_code
order by clt_ref_no asc

Now, that I have ran this and it ouputted what I needed for my true inventory I need to know how I can put this data into a table in which I can compare it to a another table that if it matches. If it matches I need the the data from the other table to be put into a file so I can export it into a .csv file.

Thats basically what I need and like again I am still new to this and still learning.

---

SELECT t.*
FROM YourMainTable t
INNER JOIN
(
select clt_ref_no, clt_id, status_code, max(list_date) as max_list_date
from inventory
where clt_id in ('A', 'B', 'C') and status_code='paid'
group by clt_ref_no, clt_id, status_code
order by clt_ref_no asc
)t1
ON t1.col=t.col1
and t1.col2=t.col2
....