i want to have a query like this.
get the record id=7
and get that records' dates from another table merging them into one
column.
let me explain this another way.
titles table
id title abstract ....
------------------------------------
....
6 test testing .....
7 test2 more testing
.....
dates table
id titleid abstract ....
------------------------------------
1 7 10.01.2001
2 7 10.02.2001
what i want to accomplish is that the query would return me a recordset
like this:
id title abstract date
---------------------------------------------------------------------------
---
7 test2 more testing 10.01.2001<br>10.02.2001
How?
Thanks....
alp