Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: combining two columns


Message #1 by "alp guneysel" <alp@t...> on Wed, 25 Apr 2001 15:54:51
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

  Return to Index