joe666666 Posted March 24, 2007 Share Posted March 24, 2007 hi, I have 2 tables: offers and requests, which both have all of the same columns: memberNo, timestamp, categoryNo, itemTitle and itemDesc. I want to view them both as one big table under the same columns (but not permanently). I know I could always just make one table in the first place with a field to distinguish between offers and requests, but i'm just wondering if it can be done. anyone know? Link to comment https://forums.phpfreaks.com/topic/44079-solved-joining-vertically-2-tables-which-have-the-same-columns/ Share on other sites More sharing options...
artacus Posted March 24, 2007 Share Posted March 24, 2007 Using 1 table w/ a type field would have been a better design. SELECT 'offer' AS type, memberNo, timestamp, categoryNo, itemTitle, itemDesc FROM offers UNION SELECT 'request' AS type, memberNo, timestamp, categoryNo, itemTitle, itemDesc FROM requests Link to comment https://forums.phpfreaks.com/topic/44079-solved-joining-vertically-2-tables-which-have-the-same-columns/#findComment-214024 Share on other sites More sharing options...
joe666666 Posted March 24, 2007 Author Share Posted March 24, 2007 Thanks thats what i was after Link to comment https://forums.phpfreaks.com/topic/44079-solved-joining-vertically-2-tables-which-have-the-same-columns/#findComment-214026 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.