vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi folks, sorry for the missing Name (its Christian) but the reason for my entry here in the usenet group is not my only computer problem today... It's late, and I have a problem that I just can't solve. I have 2 tables that look similar to this: table A: ID | firstname | lastname ------------------------------------------------ 1 | Thomas | Meier 2 | Hansi | Mueller table B: fk_ID | date | info ------------------------------------------------ 1 | 12.12.2002 | foo 1 | 11.11.2000 | bar 1 | 12.12.2003 | foo2 1 | 11.11.2005 | bar2 The output I would like to have now is the following, so only having the NEWEST "info" entry from table B together with the data from table A ID | firstname | lastname | info -------------------------------------------------------- 1 | Thomas | Meier | foo 2 | Hansi | Mueller | bar2 Is there a way to do this in one query? I just can't figure it out... Thanks in advance! Christian |