Đang Thực Hiện

132998 Access 97 SQL select query

In Access 97 I need a small SQL select query.

I have 2 tables CUSMAS and TRANSACTIONS.

There can be 0 or many dated transactions per customer.

I want to select each customer in a group (rout)'

and ONLY the one newest transaction for each customer.

If 0 transactions I still need the customer and transaction value = 0

Kỹ năng: Bất kì công việc gì, Microsoft Access

Xem thêm: the select group, n query, access group, sql microsoft access, microsoft access sql, sql microsoft, SQL Access, select, access to sql, access sql, sql select select, sql select, access sql query, sql query access, query query, small sql query, sql transaction, transaction sql, select select, access customer, customer access, small sql, query access

Về Bên Thuê:
( 1 nhận xét )

Mã Dự Án: #1879169