Sql Stored Procedure

[mrsgwen90]

I have 3 tables that I'm working with in Sql Reporting Services. tblParks, tblContacts, tblZone.

I want to say: If "ContactID" IS NULL in tblParks THEN get "ZoneCoordinato r" in tblZones.

How would I write this in Sql? Would I write it as a stored procedure?

[ck9663]

What's the key that linked these tables?

-- CK

[Delerna]

Here is how you do the use this field but if its null use another.
I don't know how the tables should join as you don't provide enough info

[code=sql]
SELECT isnull(tblParks .ContactID,tblZ ones.ZoneCordin ator) as FieldName
FROM TheTablesAndJoi nConditionsNesc essaryToProduce YourRequirement s
[/code]


If you need to pass parameters to the query for use in a WHERE clause then use a stored procedure. If no parameters (ie. the WHERE clause,if used, never changes) then use a view.