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. 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. Link to comment https://forums.phpfreaks.com/topic/232440-merge-tables/#findComment-1196252 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.