Questions about using {THISTABLE} - SOLVED

[HyperOsmar]

@troester, I hope all is well with you...

What is the importance (difference) of using {thistable} or not in databasejoins???...

As I have several databasejoins pointing to the same table, is it advisable to use them all or just from the second element, that is, it is not necessary for the first one???...

 

[troester]

It won't hurt if you use it always.

 

[HyperOsmar]

Yes, it really won't hurt, I don't mind using it, I just wanted to understand the importance of said command.

 

[troester]

It's SQL. If you have multiple joins to the same table you must use table aliases like
SELECT x,l1.col1,l2.col2 FROM table JOIN lookup as l1 ON ... JOIN lookup as l2 ON ...

Fabrik will generate these aliases automatically (like your-dbjoin-table_0, your-dbjoin-table_1 etc) and if you want to use the columns in OR CONCAT or Data-where etc. you'll need the alias which you don't know but Fabrik will replace {thistable} with the correct one.

 

[HyperOsmar]

@troester, thank you so much...