Klaus Ita wrote:
i have the following data:
table L:
LNR ORT LCODE MENGE
L1 Graz A 1000
L2 Wien C 500
L3 Wien C 1500
L4 Linz B 1000
L5 Graz B 300
table P:
PNR PNAME ORT PREIS
P1 Alpha Wien 50.00
P2 Delta Linz 95.00
P3 Sigma Linz 75.00
P4 Omega Wien 40.00
now the problem:
select l.ort;
gives:
ORT
Graz
Wien
Wien
Linz
Graz
select l.ort from p;
gives:
ORT
Graz
Wien
Wien
Linz
Graz
Graz
Wien
etc
Does it still do it if you disable "add_missing_from" in postgresql.conf?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
