[SOLVED] SQL query

[bigdspbandj]

I am having troubles with this query:

 

I have two tables:

 

Jobs

-----------

id

login_id

info1

info2

info3

 

Logins

-----------

id

customer_id

info1

info2

info3

 

I am trying to write a query that selected all info from the jobs table where the logins.customer_id = a certain value, but the query keeps returning every record in jobs. Here is the query I have as of right now. Please help!

 

SELECT * FROM d_jobs, d_logins WHERE d_logins.cust_id = 3;

 

 

Thanks!

[adam291086]

when you set up the msql database are you sure you linked the tables?

[BlueSkyIS]

you need to define the relation between the tables in your SQL:

 

SELECT * FROM d_jobs, d_logins WHERE d_logins.cust_id = 3 AND d_logins.id = d_jobs.login_id;

 

or however your tables are related. if your tables are not related, you'll need to add a relation

[bigdspbandj]

Would you know how or have a link to the mysql resource of how I can add a relationship? I never quite figured that out. Can it be done through phpMyAdmin?

[bigdspbandj]

Nevermind. I figured it out. Thanks!

 

I still  need query that pulls all jobs for a particular customer.

 

I should say I have three tables

 

jobs, logins, and customers.

 

jobs contains a FK for logins and logins contains a FK for customers.