forum

home / developersection / forums / sql foreign key between two tables

SQL foreign key between two tables

Lady Bird Johnson 2198 08-Jul-2013

Hi Expert!

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!

mssql server

Updated on 08-Jul-2013

Lady Bird Johnson

Other

Message

Can you answer this question?

1 Answers

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.

advertising