gregor malensek wrote:
>
> V oracle bi naredu :
> SELECT * FROM t1,t2 WHERE t1.idpolja=t2.id(+) -- to je outer join
V zbirki podatkov Informix pa:
SELECT * FROM t1, OUTER t2
WHERE t1.idpolja=t2.id
--
Pozdrav,
Roman
On Mon, Sep 04, 2000 at 12:41:46PM -0700, [EMAIL PROTECTED] wrote:
> Imam 2 tabeli (normalna+sifrant), ki ju obicajno zdruzim s SELECT *
> FROM t1,t2 WHERE t1.idpolja=t2.id
>
> Vse ok, problem pa je, ko vpis v t1 nima ustrezne vrednosti IDja v t2.
> Takrat ne dobim vrstice, jaz pa bi jo vseeno
V oracle bi naredu :
SELECT * FROM t1,t2 WHERE t1.idpolja=t2.id(+) -- to je outer join
Domnevam da uporabljas mysql ?
cu
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, September 04, 2000 9:42 PM
To: [EMAIL PROTECTED]
Sub
