On Thursday 21 February 2002 3:29 pm, Rick Emery wrote:
> try:
> select * from MapConfig mc LEFT JOIN ConfigString USING (id)
> LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = "Roads";
Heh. It's been too long since I worked with SQL.
Thanks, that worked perfectly.
---
D]
Subject: Linking tables using INNER JOIN
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN
ConfigInt
USING (id) WHERE MapConfig.layername = "Roads";
What I am trying to do is to pul
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt
USING (id) WHERE MapConfig.layername = "Roads";
What I am trying to do is to pull back all rows from MapConfig associated
with matchi