viviosoft Posted April 1, 2011 Share Posted April 1, 2011 Hello all, I have a simple question (well, not for me anyway). I have two tables in the same database. Each table has different field names and not the same amount of fields. Not sure if that matters or not? Anyway, I want to combine the two. I'm working on a autocomplete form which allow the user to start typing a word and they get a list of related words that match their input (much like google.com does). How would write such an SQL statement? Thanks for any help on this. Quote Link to comment https://forums.phpfreaks.com/topic/232440-merge-tables/ Share on other sites More sharing options...
fenway Posted April 3, 2011 Share Posted April 3, 2011 You can UNION the table if you use NULLs wherever the gaps are. Quote Link to comment https://forums.phpfreaks.com/topic/232440-merge-tables/#findComment-1196252 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.