Home » Developer & Programmer » Forms » how to built a dynamic sql
how to built a dynamic sql [message #202492] Fri, 10 November 2006 00:54 Go to next message
sudharshan
Messages: 48
Registered: November 2006
Member
i have a table with say - rule_component

which has two columns

1.db_table
2.from_clause

The two columns contains tables for example

db_table
------------
emp
dept
bonus
emp
def

from_clause
----------------

emp,dept,bonus,dept,emp,abc


My requirement

i want to find the duplicate tables in both the from_clause and db_table column
and populate in my from clause which are unique to both the columns


say example

select ......

from emp,dept,bonus,abc,def
Shocked
Re: how to built a dynamic sql [message #202503 is a reply to message #202492] Fri, 10 November 2006 01:46 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, do not cross-post the same question.
Previous Topic: Need to add a tab canvas
Next Topic: help needed
Goto Forum:
  


Current Time: Wed Dec 07 02:40:09 CST 2016

Total time taken to generate the page: 0.05226 seconds