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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
