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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.