[Resolved] 2 SQL results in one?

furious5

Ok heres the scenario, I have a table (job) with job details in and I have included a contactid as a foriegn key to another table.

Is there anyway in SQL that I could run 1 connection to the db and query which would allow me to get all the details from the job table, and also the relevant information from the contact table without having to run 2 queries?

ruttiger

Do a join

Select table1.somefield, table1.somefield2, table1.somefield3, table2.somefield4, table2.somefield5 ON
table1 INNER JOIN table2 ON table1.someFieldID=table2.someFieldID2

kevinsequeira

select * from job, anothertable where job.contactid = anothertable.whatever_id

reg
kevin

furious5

Ok I had thought about using a join, although I have never actually used one before.

The examples you demonstrate seem logical, my problem is that this is the SQL statement I am using.

"SELECT jobid, date, title, description, location, skills, salary, industry, contactid FROM job WHERE jobid = '$jobid' ";

BUT

I also want to execute this SQL statement:

"SELECT contactid, contact_fname, contact_lname, contact_email FROM contact WHERE contactid = job.contactid";

Could these two queries be joined in to one? Or am I asking too much?

kevinsequeira

$query = "SELECT * FROM job, contact where job.jobid='$jobID' AND job.contactid=contact.contactid";

reg
kevin

furious5

I'm struggling with the SQL you suggested, it doesn't return any results when I use that SQL.

I've printed the SQL out to screen, and it returns this:

SELECT * FROM job, contact WHERE job.jobid='3' AND job.contactid=contact.contactid

Any ideas?

kevinsequeira

is jobid a numeric or alpha-numeric variable.
are they any values that match this in the table ??
reg
kevin

furious5

There is definately a value for contactid in the job table, the jobid is a numeric value.

furious5

I've just been looking at this in more detail.

I've just printed the contactid on screen. It returns a value of 1

This is really strange as the contactid for jobid = 2.

Any ideas?