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.

8 Years
Discussion Span
Last Post by chen12m

Without a tables' structure, it is hard to give an usefull response.
As I can see, you need an inner join between table1 and table2, something like

select tbl2_name from tbl2 t2
inner join tbl1 t1 on t1.tbl1_number = t2.tbl2_number
where t1.tbl1_number = anumber



paste actual code

We don't do your homework for you.

I thought I described a very specific question. If I didn't express myself well Enough and you thought I wanted you to do the hard work for me than I'm sorry. anyways, after some tries I succeeded to solve it. but thanks anyway [=
if anyone cares, the code I came up with: SELECT tbl_table1.tbl1_num,tbl_table2.tbl2_name, FROM tbl_table1, tbl_table2 WHERE val(tbl_table1.tbl1_code) = val(tbl_table2.tbl2_code) ORDER BY tbl_table1.tbl1_num

and thanks Ionelul!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.