]]>
]]>
]]>
]]>
btw...I have a new job now (more horizontal promotions) and now I'm constantly working.
Statistics: Posted by Satis — Sat Feb 17, 2007 11:19 am
]]>
Now if you had CatID in table 2, that is another matter.
table1
id
name
description
table2
id
table1id
name
description
SELECT table1.name AS t1name, table2.name AS t2name FROM table1 LEFT JOIN table2 ON table2.table1id = table1.id WHERE table1.id = 1234;
Statistics: Posted by Pig — Fri Feb 16, 2007 6:57 pm
]]>
I have 2 tables.
table1:
CatID
Name
Description
table2:
SubCatID
Name
Description
I have the CatID and SubCatID and I want to resolve these back to the associated names. I could do two queries, but I'm sure it's possible in one query.
select [Name] FROM table1 WHERE CatID = $CatID;
select [Name] FROM table2 WHERE SubCatID = $SubCatID;
I thought maybe
select a.[Name], b.[Name]
FROM table1 a, table2 b
WHERE a.CatID=$CatID
AND b.SubCatID=$SubCatID
Also tried an OR in the where clause, but no go. Any advice?
Statistics: Posted by Satis — Fri Feb 16, 2007 9:52 am
]]>