cedtech23 Posted December 2, 2007 Share Posted December 2, 2007 how do I write a select statement that will get data from two tables This is the tables structure Patients id f_name l_name lang_id Language id lang I know that I can do "select f_name, l_name, lang_id" but I need the patients first name, last name and language. Not the lang_id example output: James Young English Link to comment https://forums.phpfreaks.com/topic/79780-solved-select-statement-for-two-tables/ Share on other sites More sharing options...
BenInBlack Posted December 2, 2007 Share Posted December 2, 2007 select patients.f_name, patients.l_name, language.lang from patients left outer join language on language.lang_id = patients.lang_id Link to comment https://forums.phpfreaks.com/topic/79780-solved-select-statement-for-two-tables/#findComment-404013 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.