neprasa Posted February 28, 2007 Report Posted February 28, 2007 ka jaraksta lai var SELECT * FROM no 3 tabulam
martins256 Posted February 28, 2007 Report Posted February 28, 2007 (edited) query= "select * from table1;select * from table2;select * from table3;" es gan nezinu ko tas dos :( Edited February 28, 2007 by martins256
andrisp Posted February 28, 2007 Report Posted February 28, 2007 Tieši ko tu gribi no tām trim tabulām ?
neprasa Posted February 28, 2007 Author Report Posted February 28, 2007 gribu ka parasti izvadit rezultatus
andrisp Posted February 28, 2007 Report Posted February 28, 2007 Nu tad vienkārši izpildi trīs selektus.
Grey_Wolf Posted March 1, 2007 Report Posted March 1, 2007 Kaads jautajums taada atbilde SELECT tabula1.* , tabula2.* , tabula_N.* FROM tabula1, tabula2, tabula_N tikai neteiksu ka saadi buus labi .... Vispaar jau shiem Merkjiem izmanto konstrukciju JOIN {LEFT} {RIGHT}{INNER} ON .... P.S hm izradaas ka forums nenjem pretii Kvadratiekavas :( [ kombinacijaa ] taa kaa aizvietoju ar {kombinacija }
andrisp Posted March 1, 2007 Report Posted March 1, 2007 Iespējams, ka viņam ir trīs tabulas ar vienādu struktūru. Tad var izmantot sql UNION.
Recommended Posts