SELECT ACCOUNT.EMAIL, ACCOUNT.FIRST_NAME, ACCOUNT.LAST_NAME
FROM ACCOUNT INNER JOIN ORDERS ON ACCOUNT.ACCOUNT_ID = ORDERS.FK_ACCOUNT_ID
WHERE (((ACCOUNT.EMAIL) Like "*@*") AND ((ACCOUNT.SEX)=2) AND ((ORDERS.ORDER_ID) Is Not Null));
Как сделать, чтобы выводил только строки с уникальным ACCOUNT.EMAIL ?
SELECT DISTINCTROW ACCOUNT.EMAIL, ACCOUNT.FIRST_NAME, ACCOUNT.LAST_NAME
FROM ACCOUNT INNER JOIN ORDERS ON ACCOUNT.ACCOUNT_ID = ORDERS.FK_ACCOUNT_ID
WHERE (((ACCOUNT.EMAIL) Like "*@*") AND ((ACCOUNT.SEX)=2) AND ((ORDERS.ORDER_ID) Is Not Null));