Retrieve random records! 1

[JojoKa]

Hi,
I am trying to run this query but I am getting an error message.

Code:
SELECT DISTINCT tbl.PROVID, tbl.[PROV NAME], tbl.SPECIALTY,tbl.[dt], top 25 ([tbl].[ID]) AS New
FROM tbl INNER JOIN tbl1 ON tbl.dt Not like tbl1.dt
ORDER BY tbl.[ID];

Error:
Syntax error(missing Operator) in query expression 'top 25([tbl].[ID])

What I am trying to do is retrieve 25 records randomly from Table (tbl) where the date field (dt) Does not equal the field (dt) in tbl1.

thanks in advance.

Joseph

 

[PHV]

something like this ?
SELECT DISTINCT TOP 25 PROVID, [PROV NAME], SPECIALTY, dt, ID
FROM tbl
WHERE dt Not In (SELECT dt FROM tbl1)
ORDER BY Rnd([ID]);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JojoKa]

Thanks soooo much. You deserve a star.
Joseph