I want to join 7 tables and fetch columns from these tables and make a different table from it, so is it possible in Timextender without creating a custom view?
Solved
I want to join 7 tables for build one table is it possible without custom view?
Best answer by rory.smith
Hi,
if you have some key columns in a table and want to add fields from other tables based on those, then you can join any number of tables and fields (obviously there are performance limits). However, if what you are doing is more complex: outer applies or intermediate aggregations or whatever other thing you can do in SQL then you may need to implement some intermediate steps. Whether or not these are useful to do in a view very much depends on the specifics.
+7Hi,
given the amount of details: yes.
I have a SQL query where they have joined 7 tables to bring out output, and I have to perform it in Timextender, so my question was, can I implement the same without creating a view in Timextender?
+4
You can't just pickup a script and expect timextender to create a table in the interface without using a view
I would like to know if it is possible to retrieve a result with 19 columns in TimeXtender by creating a relationship between the 7 tables, or if a query needs to be written to execute the operation in View. The result is 19 columns that are obtained after joining 7 tables together.
Did you get it now?
+4You can even retrieve a table with 100+ columns with 50+ tables linked to eachother. It will work as long as you start with the biggest table. A lookup cannot create more records in the start table.
+7Hi,
if you have some key columns in a table and want to add fields from other tables based on those, then you can join any number of tables and fields (obviously there are performance limits). However, if what you are doing is more complex: outer applies or intermediate aggregations or whatever other thing you can do in SQL then you may need to implement some intermediate steps. Whether or not these are useful to do in a view very much depends on the specifics.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
