ID | A | B
----------
 0 | 1 | 2

ID | Wert
----------
 1 | Test1
 2 | Test2
 3 | Test3

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 15. Juli 2006 um 17:55
-- Server Version: 5.0.18
-- PHP-Version: 5.1.1
-- 
-- Datenbank: `test`
-- 

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `t1`
-- 

CREATE TABLE `t1` (
  `sp_t1_ID` int(11) NOT NULL auto_increment,
  `sp_t2_ID1` int(11) NOT NULL,
  `sp_t2_ID2` int(11) NOT NULL,
  PRIMARY KEY  (`sp_t1_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `t1`
-- 

INSERT INTO `t1` VALUES (1, 1, 2);

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `t2`
-- 

CREATE TABLE `t2` (
  `sp_t2_ID` int(11) NOT NULL auto_increment,
  `sp_Wert` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`sp_t2_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `t2`
-- 

INSERT INTO `t2` VALUES (1, 'rot');
INSERT INTO `t2` VALUES (2, 'gruen');

SELEECT t1.* , t2.*  FROM t1 LEFT JOIN t2 ON t1.A = t2.ID WHERE t1.ID = 0