Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Algorithm for creating SQL for FROM clause

Author  Topic 

VladSkaletsky
Starting Member

1 Post

Posted - 2010-06-16 : 17:20:47
I am looking for algorithm for creating SQL for FROM clause using information about ordered set of links between pairs of tables. Each link represents one Join (left\right\inner).
If I have information about links how calculate tables order in FROM clause so result will be correct.
I am not looking for optimization, all what I need is get correct result which depends on order in which otter joins included FROM.

Thanks

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-06-17 : 04:09:14
Umh...what?? I'm sorry but I didn't understand anything of what you just wrote. Can you please provide some examples with sample data and what you want/expect to get out of it?

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page
   

- Advertisement -