Joining Multiple Tables with Postgres Driver

[Jeffrey04]

I don't have a fix for this at the moment. While joining 2 tables is fixed in #774, but when I am working on joining 3 tables, i get a query like this.

SELECT "v"."value"
FROM users u JOIN "profile_values v", "profile_fields f" ON (u.uid = v.uid) AND (f.fid = v.fid)
WHERE "uid" = '1'
    AND "profile_organization" = 'organization'

As far as i know, postgres (8.3) doesn't work this way. A proper join statement should look something like

SELECT f.name, v.value
FROM users u 
    JOIN 
        ("profile_values" v JOIN "profile_fields" f ON f.fid = v.fid)
    ON v.uid = u.uid
WHERE u.uid = 1;

[Jeffrey04]

quick fix

			$sql .= ' '.$database['join']['type'].'JOIN '.implode(', ', $database['join']['tables']).' ON '.implode(' AND ', array_reverse($database['join']['conditions'], TRUE));

[Jeffrey04]

sorry.. the above patch didn't work

[postlogic]

Working quick fix

$sql .= ' '.$databasejoin?type?.'JOIN ';

if (count($databasejoin?tables?) > 1) {

$sql .= '('.implode(', ', $databasejoin?tables?).') ON '.implode(' AND ', $databasejoin?conditions?);

} else {

$sql .= implode(', ', $databasejoin?tables?).' ON '.implode(' AND ', $databasejoin?conditions?);

}

[postlogic]

Err, proper formatting..

			$sql .= ' '.$database['join']['type'].'JOIN ';
			
			if (count($database['join']['tables']) > 1) {
				$sql .= '('.implode(', ', $database['join']['tables']).') ON '.implode(' AND ', $database['join']['conditions']);
			} else {
				$sql .= implode(', ', $database['join']['tables']).' ON '.implode(' AND ', $database['join']['conditions']);
			} 

[Shadowhand]

Duplicate of #779.