web_master Posted March 2, 2011 Share Posted March 2, 2011 Hi, I got a problem with Joining tables. I dont know what is the solution, please help me. SELECT `x700`.x700_id, `x700`.x700_radninalog, `x700`.x700_worker, `x700`.x700_notworker, user.user_id, user.user_name, user.user_formname FROM `x700` Inner Join user ON user.user_id = `x700`.x700_worker AND user.user_id = `x700`.x700_notworker The problem is that the `x700_worker` and the `x700_notworker` is taken from the `user` table. How can I separate that I can print on screen the workers name (x700_worker) and the "notworker"-s (x700_notworker) name too? thanks in adwanced, T Link to comment https://forums.phpfreaks.com/topic/229398-problem-with-joining-tables/ Share on other sites More sharing options...
fenway Posted March 2, 2011 Share Posted March 2, 2011 Join twice. Link to comment https://forums.phpfreaks.com/topic/229398-problem-with-joining-tables/#findComment-1182007 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.