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? Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
joe666666 Posted March 24, 2007 Author Share Posted March 24, 2007 Thanks thats what i was after 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.