Hi
I have an database with some tables in it. each two of the tables are related together. i want to ask how can i search in the database with one query and find the results of it with the rows of the other table that are related to it beside it with the same query?
for example i have 2 tables named "table1" with fields:'code, date, ...'
and a table called "related-to-table1" with fields:'code, text, id, ...'. The table's are related by code and in "table1", "code" is an auto increment field but in "related-to-table1" it's not and for each code in "table1" there could be more than one in the other table.
I want to see how can i search between a specific date in "table1" and select every row from the "related-to-table1" where its code in "table1" has the date we want?
sorry for the long question and my English!
thanks!