Join på tabel

select fritid_stamoplysninger.* from fritid_stamoplysninger as fs, fritid_modested as fm where fs.modestedid = fm.modestedid

burde kunne gøre det

$result = $parser->D->dbQuery("select fritid_stamoplysninger.* from fritid_stamoplysninger as fs, fritid_modested as fm " . $parser->D->table . " where fs.modestedid = fm.modestedid ");

Der er en fejl

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fritid_modested where fs.modestedid = fm.modestedid LIMIT 2' at line 1

Jeg har stadig

$parser->D->dbSetTable("fritid_modested");

først

$result = $parser->D->dbQuery("select fritid_stamoplysninger.* from fritid_stamoplysninger as fs, fritid_modested as fm " . $parser->D->table . " where fs.modestedid = fm.modestedid ");

ændres til

$result = $parser->D->dbQuery("select fritid_stamoplysninger.* from fritid_stamoplysninger as fs, fritid_modested as fm  where fs.modestedid = fm.modestedid ");

Lige en rettelse:

$result = $parser->D->dbQuery("select * from fritid_stamoplysninger as fs, fritid_modested as fm  where fs.modestedid = fm.modestedid ");

Perfekt, tak for hjælpen.