Toad World® Forums

I want latest list

Hi, everyone.

I have a question.

I know two tables, one table is guest proplie. another table is guest record.

For example, A customer bought a bag on the 01-08-2011 to visit.

and A customer bought a dress on the 11-04-2012 to visit.

Query criteria is bags and clothes from the store customers who bought Be.

However, the list shows a list of the most visited in the last turn.

I make query

select *
from guest_proplie
where guest_no In (select distinct(guest_no)
from guest_record
where itcode in (‘bag’, ‘dress’));

I don’t know lastest list query.

please, teach me.