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 Quote Link to comment Share on other sites More sharing options...
fenway Posted March 2, 2011 Share Posted March 2, 2011 Join twice. 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.