Hi,

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?

@Karankadam Like Rory's says. You are not giving much information so yes you should be able to do it with lookups. But this question isn't giving any information about anything. 
 

You can't just pickup a script and expect timextender to create a table in the interface without using a view

@Bernarddb @rory.smith 
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?

You 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.

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.

@rory.smith  Thankyou