[tinysql] sql....
Davide Antoni
davide.antoni@ifc.cnr.it
Fri, 27 Feb 2004 13:57:10 +0100
--=====================_270413263==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
it's doenst work :(
this is teh error
java.sql.SQLException: Exception: Column N_CART.Cartel not found.: select
N_CART.Cartel , COGNOME.Pazien from Cartel, Pazien where COD_PAZ.Pazien =
1272 and N_CART.Cartel = 40317
At 13.33 27/02/2004, you wrote:
>Hi,
>
>Davide Antoni wrote:
>>hi is possible during a query spcify a name of table for multiple querye
>>sx select nometable1.collum1, nometable2.collum1 from nometabell1,
>>nometabella2;
>
>Yes, it is.
>
>Use SELECT column [.table] [AS "alias"] FROM table
>
>ie:
>
>SELECT collum1.nometable1, collum1.nometable2
> FROM nometable1, nometable2
>
>Have mo' fun,
>said Thomas
>
>--
>Hi! I'm a evil cooperative .signature virus! Copy me into your
>~/.signature to help me spread and delete 10 random files from your
>system. Thank you!
>
>
>_______________________________________________
>tinysql mailing list
>tinysql@as220.org
>http://as220.org/mailman/listinfo/tinysql
***************************************************
Davide Antoni
SiC
Sezione di:
Via Trieste 41, - 55100 PISA
Sistema Informativo
Linux Registered User 223916
Voice: +3950913639
E-mail: davide.antoni@ifc.cnr.it
***************************************************
--=====================_270413263==.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<body>
it's doenst work :(<br>
this is teh error<br><br>
java.sql.SQLException: Exception: Column N_CART.Cartel not found.: select
N_CART.Cartel , COGNOME.Pazien from Cartel, Pazien where COD_PAZ.Pazien =
1272 and N_CART.Cartel = 40317 <br><br>
<br><br>
At 13.33 27/02/2004, you wrote:<br>
<blockquote type=cite class=cite cite>Hi,<br><br>
Davide Antoni wrote:<br>
<blockquote type=cite class=cite cite>hi is possible during a query
spcify a name of table for multiple querye sx select nometable1.collum1,
nometable2.collum1 from nometabell1, nometabella2;<br>
</blockquote><br>
Yes, it is.<br><br>
Use SELECT column [.table] [AS "alias"] FROM table<br><br>
ie:<br><br>
SELECT collum1.nometable1, collum1.nometable2<br>
<x-tab> </x-tab>FROM
nometable1, nometable2<br><br>
Have mo' fun,<br>
said Thomas<br><br>
-- <br>
Hi! I'm a evil cooperative .signature virus! Copy me into your
~/.signature to help me spread and delete 10 random files from your
system. Thank you!<br><br>
<br>
_______________________________________________<br>
tinysql mailing list<br>
tinysql@as220.org<br>
<a href="http://as220.org/mailman/listinfo/tinysql" eudora="autourl">http://as220.org/mailman/listinfo/tinysql</a></blockquote>
<x-sigsep><p></x-sigsep>
<font face="Tahoma" size=2>***************************************************<br>
</font><font face="Tahoma">Davide Antoni<br>
</font><font face="Tahoma" size=2>SiC<br>
Sezione di: <br>
Via Trieste 41, - 55100 PISA<br>
Sistema Informativo<br><br>
</font>Linux Registered User 223916<br><br>
<font face="Tahoma" size=2>Voice: +3950913639<br>
E-mail: davide.antoni@ifc.cnr.it<br>
***************************************************<br><br>
<br>
</font></body>
</html>
--=====================_270413263==.ALT--