[Webpro] Q on SQL query...

[jsWalter]

Thanks, but I have it now...

SELECT
    a.st_id,
    a.st_name,
    b.con_id,
    b.con_name
FROM
    stations AS a
LEFT OUTER JOIN
    contacts AS b
ON
    a.st_id = b.st_id
ORDER BY
    a.st_name

Works like a charm.

Walter