I've got the need to select everything from table1 and only 1 row from table2. Table2 can hold any number of rows from 0 to 10,000
I've tried the following with no joy. Any ideas?
SELECT DISTINCT (ID) AS Expr1, *
FROM aacc LEFT JOIN awardsQuery ON aacc.ID = tbl2.feildID;
This still brings back IDs that are the same!