sandy1028 Posted October 31, 2007 Share Posted October 31, 2007 Hi, I have table A with the fields jobid | varchar(20) | NO | PRI | | | | jobname | varchar(30) | YES | | NULL | | | owner | varchar(15) | YES | | NULL | | | queue | varchar(10) | YES | | NULL | | |flag I have table B with fields jobid | varchar(20) | NO | PRI | | | | jobname | varchar(30) | YES | | NULL | | | owner | varchar(15) | YES | | NULL | | | queue | varchar(10) | YES | | NULL | | | exittime I should select all data from table A and also from table B. How can I select all the jobname's from A and B Quote Link to comment https://forums.phpfreaks.com/topic/75469-select-from-two-tables/ Share on other sites More sharing options...
Zane Posted October 31, 2007 Share Posted October 31, 2007 try this SELECT a.*, b.* FROM table1 a, table2 b Quote Link to comment https://forums.phpfreaks.com/topic/75469-select-from-two-tables/#findComment-381764 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.