<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Forum PostgreSQL - Pomoc w join-owaniu tabel]]></title>
		<link>https://forum.postgresql.org.pl/viewtopic.php?id=1489</link>
		<description><![CDATA[Najświeższe odpowiedzi w Pomoc w join-owaniu tabel.]]></description>
		<lastBuildDate>Tue, 30 Apr 2013 13:22:53 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Odp: Pomoc w join-owaniu tabel]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=4168#p4168</link>
			<description><![CDATA[select * 
from b
left join a as a1 on a1.id=b.fk_1
left join a as a2 on a2.id=b.fk_2]]></description>
			<author><![CDATA[dummy@example.com (c_michal)]]></author>
			<pubDate>Tue, 30 Apr 2013 13:22:53 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=4168#p4168</guid>
		</item>
		<item>
			<title><![CDATA[Pomoc w join-owaniu tabel]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=4167#p4167</link>
			<description><![CDATA[Mam tabele
[code]A
    id
    ....[/code]

Oraz
[code]B
    ...
    fk_1          będąca foregin key do A.id
    fk_2          będąca foregin key do A.id[/code]

Jak napisać takiego selecta:

[code]select A.*, B.*
from B
    inner join A
        on B.fk_1 = A.id
    inner join A
        on B.fk_2 = A.id;[/code]
bo teraz dostaję error
[quote]BŁĄD:  nazwa tabeli "A" określona więcej niż raz[/quote]]]></description>
			<author><![CDATA[dummy@example.com (tomek)]]></author>
			<pubDate>Tue, 30 Apr 2013 10:39:12 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=4167#p4167</guid>
		</item>
	</channel>
</rss>
