I have to finish this project for tomorrow-so I'll Appreciate quick reply.
I need to do reports in my projects. now I've created Data Environment and all that but in the SQL the only thing that work is if I select the entire table from the database. (like "select * from tbl_table" the problem is, I have one Variable that I need from another table(because it appears as a number in table1 and the name is written in table2-and I need the name. so I tried to write "select tbl2_name from tbl2 where tbl1_number=tbl2_number"
well..something like that..
I got here from google so I don't know the rules here or anything..sorry if I did something wrong.