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.
Thank’s.