On Thu, 1 Feb 2001, Brice Ruth wrote:
->SELECT
-> a.Number,
-> a.Code,
-> a.Text
->FROM
-> b,
-> a
->WHERE
-> (b.Id = a.Id) AND
These next two statements are very ambiguous. Make them explicit as you have
with "(b.Id = a.Id)" and "(b.d_Id = 'key3')"
Also, be sure that 'key3' is how what you want looks in the database
-> (VersionId = 'key1') AND
-> (Category = 'key2') AND
-> (b.d_Id = 'key3')
->ORDER BY
-> a.Number;
Also, make sure ( '\d b' ) that your columns are case-sensatively named 'Id' and
such as this does matter.
-- Dave