How to retrieve all data from two table in mysql?

Asked Feb 21 '17 at 00:29

Active Feb 21 '17 at 00:52

Viewed 30 times

I have 2 tables: "tbl_file" and "tbl_product"

I need to retrieve all data from both tables where "tbl_file" has a name, city, country and license number. Table "tbl_product" only stores the brand and type of product(1 - 5).

My problem is that when i try to retrieve data and it only display the "tbl_file" data only and empty for "tbl_product".

Below is the code :

$sql = "SELECT tbl_file.* ,tbl_product.* 
        FROM tbl_file ,tbl_product 
        WHERE CompName LIKE '%$company_name%' 
           OR License_No LIKE '%$License_no%'";

edited Feb 21 '17 at 00:52

RiggsFolly

93,638
21
103
149

asked Feb 21 '17 at 00:29

rat21ful

2

Read up on [table joins](https://dev.mysql.com/doc/refman/5.7/en/join.html) – Xorifelse Feb 21 '17 at 00:31
`WHERE tbl_file.linkColumn = tbl_product.link_column` You needto tell MYSQL how these 2 tables are linked – RiggsFolly Feb 21 '17 at 00:53
related/duplicates: http://stackoverflow.com/questions/5294311/difference-between-these-two-joining-table-approaches http://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause – mickmackusa Feb 21 '17 at 00:54
Thanks @Xorifelse – rat21ful Feb 21 '17 at 01:06

How to retrieve all data from two table in mysql?

0 Answers0