How to Retrieve Record from Two Tables in PHP??

When you want to retrieve record from different table of same database in PHP then don’t worry.

Here our team give you solution for that problem.

You can easily retrieve record from two table using join query. There are three types of join available in SQL.

1. Inner Join
2. Outer Join
3. Cross Join

For example if you want to retrieve record product from prd table and category from cat table then you can fire below query.

Select procuct.prd,category.cat from prd,cat where catid.prd=catid.cat

In above query prd and cat is table name

To retrieve record from two tables where clause is most important.

How to Retrieve Record from Two Tables in PHP??

View more bank vacancies

View more vacancies of government sector

View more vacancies of private sector

View more vacancies of IT sector

Atomic Energy Department 20 Apprentices Latest Recruitment igcar.ernet.in

NARL Scientist Engineer 5 Recruitment 2014 narl.gov.in

CIFT 21 Technical Assistant 2014 Recruitment cift.res.in

HGB Bank 200 Office Assistant 2014 Recruitment hgb.co.in

Central Excise & Customs 19 Tax Assistant 2014 Recruitment

CSIR Dhanbad 02 Project Assistant Recruitment cmriindia.nic.in

IGM Hyderabad 32 Technician Recruitment igmhyderabad.spmcil.com

ECHS 12 Staff 2014 Recruitment echs.gov.in

APPSC Specialist Doctors 2014 Recruitment appsc.gov.in

APSC Various Recruitment 2014 apsc.nic.in