I got the table (node_table):
nid , title, type, created, published
DATA:
1, JOHN WRITER, writer, 27-10-2007, 1
2, Article ONE, article, 21-10-2007, 1
3, Article TWO, article, 22-10-2007, 1
4, Article THREE, article, 21-11-2007, 0
5, Article FOUR, article, 22-11-2007, 1
6, TOMMY WRITER, writer, 27-10-2007, 1
7, Article FIVE, article, 22-11-2007, 1
8, Article SIX, article, 23-11-2007, 1
another table (writer_article_table)
writer_nid, article_nid
DATA:
1 , 2
1 , 3
1 , 4
1 , 5
6 , 7
6 , 8
i need a select statement that displays for me all writers type, and the last article for each writer
THE RESULTS MUST BE:
JOHN WRITER(ID:1) - Article FOUR (ID:5)
TOMMY WRITER(ID:6) - Article SIX (ID:8)