joining two or more tables dynamically

S

shafee212

Member
i want to join two or more than 2 tables dynamically..
ie . on the run time itself , user should input the table names and the condition of joining the two tables .

for eg i want to joi pt_mstr and ps_mstr

and the condition is pt_part = ps_mstr

i want to dynamically accept tables at run time and also the joining condition at run time .

tables could be more than 2
 
If you are running version 9 or greater then you can use dynamic queries.

There are a lot of examples in this forum. Some of them are quite recent. Search for "query-prepare".
 
You must log in or register to reply here.
Back
Top