SQL help

[Nipplemilk909]

hello im trying to list candidate 2's total job history and thier current job placement. 

my faulty current sql code 

 

SELECT j.Candidate_ID,
             j.Job_tittle,
             p.Candidate_ID,
              p.Job_tittle
FROM Job_History j,
            Placement p
WHERE j.Candidate_ID = p.Candidate_ID
              and j.Candidate_ID = 2
               and 

[SCHISCHKA]

it is not complete and you prob have to put '2' with the appropriate quote marks

WHERE j.Candidate_ID = p.Candidate_ID
              and j.Candidate_ID = 2
               and 

 

[afyeung]

29 minutes ago, SCHISCHKA said:

it is not complete and you prob have to put '2' with the appropriate quote marks

WHERE j.Candidate_ID = p.Candidate_ID
              and j.Candidate_ID = 2
               and 

 

Aren't quotation marks for strings? 

[Nipplemilk909]

SELECT j.Candidate_ID,
               j.Job_tittle,
                p.Candidate_ID,
                 p.Job_tittle
FROM Job_History j,
            Placement p
WHERE j.Candidate_ID = p.Candidate_ID
              and (j.Candidate_ID = '2')
;

 

 

 

 

gives me an error 

[madknight3]

"Job_tittle" looks like a typo to me.

[SCHISCHKA]

27 minutes ago, afyeung said:

Aren't quotation marks for strings? 

depends on the database engine and the data type; thats why i say probably 

[Nipplemilk909]

4 minutes ago, SCHISCHKA said:

depends on the database engine and the data type; thats why i say probably 

its accses and its an auto number 

 

 

 

 

after correcting the spelling it outputs an error data type error mismatch i dont understand what is the data mismatch

[madknight3]

11 minutes ago, Nipplemilk909 said:

its accses and its an auto number 

 

 

 

 

after correcting the spelling it outputs an error data type error mismatch i dont understand what is the data mismatch

It probably has to do with this

 

j.Candidate_ID = 2

vs

j.Candidate_ID = '2'

 

Use the correct data type for the column Candidate_ID

[Nipplemilk909]

1 minute ago, madknight3 said:

It probably has to do with this

 

j.Candidate_ID = 2

vs

j.Candidate_ID = '2'

 

Use the correct data type for the column Candidate_ID

yep it was thank you!