ds111 Posted March 8, 2010 Share Posted March 8, 2010 Hello! I have the following two tables: table1: --------------------------- | RID | NAME | | 1 | Bob | | 2 | Mark | | 3 | Sue | --------------------------- table2: --------------------------- | RID | RID2 | | 1 | 2 | | 2 | 3 | | 1 | NULL | --------------------------- I need an SQL Statement that will print out the following: RID: 1 NAME: Bob RID2: 3 NAME: Sue Can you help me construct this statement? Link to comment https://forums.phpfreaks.com/topic/194561-mysql-join-statement-help/ Share on other sites More sharing options...
fenway Posted March 15, 2010 Share Posted March 15, 2010 Why not a simple join/ Link to comment https://forums.phpfreaks.com/topic/194561-mysql-join-statement-help/#findComment-1026469 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.