Re: SQL help

The t1 an t2 are aliases wehich I use when working multiple joins within the same table and/or the table names are very big. In this case t1 and t2 are referencing the same table but on diferent queries. Notice that the sintax is: select .... from tablename1 alias1,tablename2 alias2,.....,tablenameN aliasN with a spaces between the table name and the alias. > >That looks like exactly what I need, however, I am not familiar with the t1 >and t2 arguments. Are they temporary table designations? I tried the above >suggestions but I received the following error {Error -217 during prepare: >Column (%s) not found in any table in the query. } >I think SQL was looking for a table NAMED invoicest1, which, obviously, >there isn't. >Do I have some bad syntax? >I replaced the "t1.cust_name" with "1 cust_name" (no period) and received a >syntax error. >I think I am getting really close, with your help. >Thanks >Rick W > > >