azraelGG Posted November 24, 2012 Share Posted November 24, 2012 can you help me with this code i want select all fields from 3 tables but i need specific names for 2 coloums SELECT mp.naziv AS mpnaziv,vm.naziv AS vmnaziv, * (i want add this * like select all but when i add that * then query doesnt work) FROM mehanizacija m, mehanizacija_proizvodjac mp, vrsta_mehanizacija vm WHERE m.meh_proiz_ID_FK=mp.meh_proiz_ID AND m.vrsta_mehanizacija_ID_FK=vm.vrsta_mehanizacija_ID any suggestions, solutions? Quote Link to comment https://forums.phpfreaks.com/topic/271119-sql-help/ Share on other sites More sharing options...
fenway Posted November 24, 2012 Share Posted November 24, 2012 Add * first, then add aliases. Quote Link to comment https://forums.phpfreaks.com/topic/271119-sql-help/#findComment-1394812 Share on other sites More sharing options...
azraelGG Posted November 24, 2012 Author Share Posted November 24, 2012 yea it works now, it loads it normal + 2 cols that i need. thanks Quote Link to comment https://forums.phpfreaks.com/topic/271119-sql-help/#findComment-1394829 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.