SQL Statement help

[Bakedgoods]

Can't figure out this SQL statement, two tables..

tblCodes
CodeID
CodeCategory

tblHours
TimeCode
blah
blah
blah
blah

Trying to SELECT all fields from tblHours where the CodeCategory = @SelectedCodeCategory

Been messing for a little but I just can't get anything working. Can anyone help?

 

[Manlove is my forte]

select *
from tblHours, tblCodes
where tblHours.CodeCategory = tblCodes.CodeCategory
and tblCodes.CodeCategory = :value


Or

select * from tblHours
where tblHours.CodeCategory = (select CodeCategory from tblCodes where CodeCategory = :value);

Both the above should work in Oracle

 

[Bakedgoods]

T-SQL sorry

 

[Manlove is my forte]

T-SQL sorry

Should mostly still work SQL is SQL at the end of the day, not sure about the bind variables thought ( :value ).

 

[voodooflux]

SELECT * from tblHours
JOIN tblCodes
ON tblHours.TimeCode = tblCodes.CodeID
WHERE tblCodes.CodeCategory = @SelectedCodeCategory

This is on the assumption that the TimeCode column on the Hours table relates to the CodeID column on the Codes table.

 

[Bakedgoods]

SELECT * from tblHours
JOIN tblCodes
ON tblHours.TimeCode = tblCodes.CodeID
WHERE tblCodes.CodeCategory = @SelectedCodeCategory

This is on the assumption that the TimeCode column on the Hours table relates to the CodeID column on the Codes table.

Cheers, yes TimeCode does relate to CodeID

How do I limit the fields from tblCodes, I only need CodeCategory really...

 

[voodooflux]

How do I limit the fields from tblCodes, I only need CodeCategory really...

SELECT tblHours.*, tblCodes.CodeCategory from tblHours
JOIN tblCodes
ON tblHours.TimeCode = tblCodes.CodeID
WHERE tblCodes.CodeCategory = @SelectedCodeCategory

 

[Scougar]

As above rather than * (which is select everything), just define the columns you need.

Matthew

 

[Stelly]

If you need help mate, just mail me everything that you need... and the SQL script so far...

Stelly

 

[Bakedgoods]

It's all sorted now thanks

I've never actually used a JOIN just nested SELECT statements

 

[Stelly]

hmmm... I'm sure that a JOIN will work faster mate, but there you do

Stelly