Delete from right join

Поиск

Список

Период

Сортировка

От	Chad Thompson
Тема	Delete from right join
Дата	7 января 2003 г. 15:10:36
Msg-id	00da01c2b688$8c5a2280$32021aac@chad обсуждение исходный текст
Ответы	Re: Delete from right join
Список	pgsql-novice

I have the following query

select project_lists.*
FROM temp_lol RIGHT JOIN project_lists ON temp_lol.project_id = project_lists.project_id
WHERE temp_lol.project_id Is Null

I run this on my postgresql 7.2.x database and it returns some 3k records.

If i use a join or a left join it returns no data.

If I do this however

DELETE

FROM temp_lol RIGHT JOIN project_lists ON temp_lol.project_id = project_lists.project_id
WHERE temp_lol.project_id Is Null

I get an error, Parse error at or near right.

I realize that right joins are evil, but I dont know what else to use to delete these 3k records from my table.

Any Ideas?

Thanks

Chad

В списке pgsql-novice по дате отправления: