Praetorian Posted September 26, 2008 Share Posted September 26, 2008 I'm trying to build a query to get all the columns from two different tables. I don't want to do a join, I just want to get all the info from both tables. Just doing "SELECT * FROM table1, table2 WHERE field1 LIKE %" Is not working. The field I'm comparing the % to is the same in both tables.Help please. Link to comment Share on other sites More sharing options...
Synook Posted September 27, 2008 Share Posted September 27, 2008 LIKE % is not valid. You may mean LIKE "%" but since that just means 'like anything' then it is superfluous.Do you mean to use UNION? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.