Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

SQL foreign key between two tables

Lady Bird Johnson 2256 08 Jul 2013

I was wondering if anyone could lead me through this SQL query.

I have two tables CS_JOBS and CS_JOBS_CATEGORY. They both have category_code row which I want to join.

PS: I will use these tables to populate the drop down box in php.

Thank you!

Lady Bird Johnson

Other

1 Answers

AVADHESH PATEL 08 Jul 2013

Hi Lady!

Try as following

SELECT -- what you want to select

FROM CS_JOBS AS j

INNER JOIN CS_JOBS_CATEGORY AS c ON j.category_code = c.category_code;

I hope it helpful for you.

MindStick Training