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? 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. 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 Link to comment https://forums.phpfreaks.com/topic/271119-sql-help/#findComment-1394829 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.