Problem z zapytaniej do bazy Oracle..., (column ambiguously defined) Opcje

[loozaque]

Witam,

Mam problem z zapytaniem do bazy oracle...

[SQL] pobierz, plaintext 
$sql = "select a.ile_mam as ile_mam_0, b.ile_mam as ile_mam_1, c.ile_mam as ile_mam_3, d.ile_mam as ile_mam_4, e.ile_mam as ile_mam_8, f.ile_mam as ile_mam_40, g.ile_mam as ile_mam_50, h.ile_mam as ile_mam_100, i.ile_mam as ile_mam_150, j.ile_mam as ile_mam_200, k.ile_mam as ile_mam_400, l.ile_mam as ile_mam_450 FROM ht_rejna a, ht_rn001 b, ht_rn003 c, ht_rn004 d, ht_rn008 e, ht_rn040 f, ht_rn050 g, ht_rn100 h, ht_rn150 i, ht_rn200 j, ht_rn400 k, ht_rn450 l WHERE is_deleted='N' AND indeks='78000'";
[SQL] pobierz, plaintext 

przejrzyściej...

[SQL] pobierz, plaintext 
$sql = "select a.ile_mam as ile_mam_0,
                b.ile_mam as ile_mam_1,
                c.ile_mam as ile_mam_3,
                d.ile_mam as ile_mam_4,
                e.ile_mam as ile_mam_8,
                f.ile_mam as ile_mam_40,
                g.ile_mam as ile_mam_50,
                h.ile_mam as ile_mam_100,
                i.ile_mam as ile_mam_150,
                j.ile_mam as ile_mam_200,
                k.ile_mam as ile_mam_400,
                l.ile_mam as ile_mam_450
                FROM ht_rejna a,
                ht_rn001 b,
                ht_rn003 c,
                ht_rn004 d,
                ht_rn008 e,
                ht_rn040 f,
                ht_rn050 g,
                ht_rn100 h,
                ht_rn150 i,
                ht_rn200 j,
                ht_rn400 k,
                ht_rn450 l WHERE is_deleted='N' AND indeks='78000'";
[SQL] pobierz, plaintext 

Zwracany komunikat:

[XML] pobierz, plaintext 
Warning:  ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-00918: column ambiguously defined
 in /home/webmaster/www/temp/oracle.php on line 56
 
 
Warning:  ocifetchinto() [function.ocifetchinto]: OCIFetchInto: ORA-24374: define not done before fetch or execute and fetch
 in /home/webmaster/www/temp/oracle.php on line 57
[XML] pobierz, plaintext 

Nie wiem co jest niejednoznacznego w tym (IMG:http://forum.php.pl/style_emoticons/default/blinksmiley.gif)

* Jest to sprawdzanie stanów magazynowych na poszczególnych magazynach, stąd zmiana nazw kolum, aby się nie dublowały - nie wiem czy to dobrze zrobiłem (IMG:http://forum.php.pl/style_emoticons/default/sad.gif) jestem początkującym....

[SongoQ]

W where wstaw nazwy tabel, brakuje Ci w where zlaczen tabel.

[loozaque]

W where wstaw nazwy tabel, brakuje Ci w where zlaczen tabel.

Dzięki wielkie, nie wiem jak to przeoczyłem, przecież to było oczywiste... (IMG:http://forum.php.pl/style_emoticons/default/angrysmiley.gif)