If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example:

SELECT l.id, l.url, r.comment

FROM ggl_links l, ggl_rates r WHERE l.id = r.id

GO

id url     comment

101  www.rendc.org  The best

102  www.rendc.org/html Well done

103  www.rendc.org/sql Thumbs up