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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
ted_chou12 Posted October 31, 2009 Author Share Posted October 31, 2009 thanks! 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.