neprasa Posted February 28, 2007 Report Share Posted February 28, 2007 ka jaraksta lai var SELECT * FROM no 3 tabulam Link to comment Share on other sites More sharing options...
martins256 Posted February 28, 2007 Report Share 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 Link to comment Share on other sites More sharing options...
andrisp Posted February 28, 2007 Report Share Posted February 28, 2007 Tieši ko tu gribi no tām trim tabulām ? Link to comment Share on other sites More sharing options...
neprasa Posted February 28, 2007 Author Report Share Posted February 28, 2007 gribu ka parasti izvadit rezultatus Link to comment Share on other sites More sharing options...
andrisp Posted February 28, 2007 Report Share Posted February 28, 2007 Nu tad vienkārši izpildi trīs selektus. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted March 1, 2007 Report Share 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 } Link to comment Share on other sites More sharing options...
andrisp Posted March 1, 2007 Report Share Posted March 1, 2007 Iespējams, ka viņam ir trīs tabulas ar vienādu struktūru. Tad var izmantot sql UNION. Link to comment Share on other sites More sharing options...
Recommended Posts