ted_chou12 Posted October 31, 2009 Share Posted October 31, 2009 hi, if i have two tables: idtitledate 1atoday 2[b today numbertitledate 1cyesterday 2dtoday if i want to echo out a table like: titledate atoday btoday dtoday only entries that are from "today" and the columns of two tables are not necessary the same or the same no. or columns. So far I tried join and left join, but things seems to come out as multiples, dont know why, if you need more inforamtion, please let me know, thanks, Ted Link to comment https://forums.phpfreaks.com/topic/179719-solved-joining-entries-by-rows-not-columns/ Share on other sites More sharing options...
kickstart Posted October 31, 2009 Share Posted October 31, 2009 Hi Looks like all you need is a UNION of 2 SELECTs, one from each table. All the best Keith Link to comment https://forums.phpfreaks.com/topic/179719-solved-joining-entries-by-rows-not-columns/#findComment-948278 Share on other sites More sharing options...
ted_chou12 Posted October 31, 2009 Author Share Posted October 31, 2009 thanks! Link to comment https://forums.phpfreaks.com/topic/179719-solved-joining-entries-by-rows-not-columns/#findComment-948388 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.