Gossamer Forum
Home : Products : DBMan SQL : Discussion :

SQL statements with table alias

Quote Reply
SQL statements with table alias
The following SQL statement gives exactly the results I need:

SELECT *
FROM
table1 AS alias1,
table1 AS alias2,
table2,
table3,
table4
WHERE
table4.fk1=alias1.pk AND
table2.fk=alias2.pk AND
table4.fk2=table3.pk AND
table3.fk=table2.pk

But how can I use this sql query in DBMan SQL? How can I fire the query and refer to its results in DBMan SQL user templates? Is it possible to use table aliases in DBMan SQL?

I am quite new to DBMan SQL and every advice is very much appreciated!