Re: Help with concat

[Peter Brawley]

If a column is specified as a constant in the Where clause, it's redundant in the Select list.

If there's just one table in the From clause, nothing's gained by qualifying column names with the table name.

And if the columns to be selected are predetermined too, the table name isn't a variable, so there's no need for Prepare, assuming a table named tbl ...

select amount from tbl where vesselid = p_vesselID;

If there's a reason we can't see that you need Prepare, you still don't need qualified column names and you otherwise're close ...

set @s = concat( "select amount from ", @t, " where vesselID = ", @v );