a complex sql query, high hand help!!!# Database - 数据库
w*n
1 楼
let say i have a table
called log:
which has colum agentID, logID, type, customerID
and another table called agent have agentID
and another table called customer have customerID
type can be car, or hotel.
and one customer can rent car from same agent at many
different
times. how do i found out customer who have rent car more
than twice from
the same agent?
called log:
which has colum agentID, logID, type, customerID
and another table called agent have agentID
and another table called customer have customerID
type can be car, or hotel.
and one customer can rent car from same agent at many
different
times. how do i found out customer who have rent car more
than twice from
the same agent?