T- Bone wrote:
> (second attempt in two days to post this message...I appologise if for
> some reason a duplicate appears)
>
> Hello all,
>
> I created a query that contains two subqueries and joins and would like
> some feedback on whether:
> 1) this approach is logical; and,
> 2) if this is an optimal approach (performance wise) to return the
> records I seek.
Well you could just do:
SELECT
l.*, c1.catname, c2.catname, c3.catname
FROM
tbl_listing l,
tbl_categories c1,
tbl_categories c2,
tbl_categories c3
WHERE
l.catid1 = c1.catid
AND l.catid2 = c2.catid
AND l.catid3 = c3.catid
--
Richard Huxton
Archonet Ltd