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