[tinysql] sql....

Taq taquera@sherito.org
Fri, 27 Feb 2004 13:33:04 +0100


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!