IF-ELSE in stored proc.

[scrooge]

Hi everybody

I've 2 tables tbl1 and tbl2 with same structure

lets say like: id and name as field

i'll send 'name' to stored procedure then it should see if 'name' exists in tbl1 then some statement should be exectued or if tbl2 has this name then some statement shoudl be exectued

example

If (select name from tbl1 where name=name) then

statement....

Else (select name from tbl2 where name=name) then
stament...

tbl1 has priority on tbl2 if name is found in tbl1 then tbl2 should be skipped.

I was unable to do it in stored proc, can someone guide me how to get it fixed?

Thanks a million -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[pinnacle]

Code:

select 1 as tbl from tbl1 where name='name'
union all
select 2 from tbl2 where name='name'
order by tbl limit 1this will give you one of the following three result sets --

Code:
tbl tbl tbl
--- --- ---
NULL 1 2 now you can do an IF on the result and then you can execute whatever you want

hope that helps -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --