Help with concat

[Russel James]

Hi folks,

I have the following sql inside a sproc that works fine.


SET @t = p_tbl;
SET @v = p_vesselID;;
SET @p = p_period;


SET @s = CONCAT("SELECT * FROM ", @t, " WHERE vesselID = ", @v , " AND period >= ", @p, " ORDER BY pKey");

PREPARE stmt FROM @s;

EXECUTE stmt;


Instead of Selecting all the fields (SELECT *) I just want to select certain fields (SELECT ledger.vesselID, ledger.amount FROM ledger...). How do I write it so that I can include the tableName @t.

Something like:
SET @s = CONCAT("SELECT , @t, ".vesselID, ", @t, ".amount " FROM ", @t, " WHERE vesselID = ", @v ,

But the above sql does not compile.
Any ideas ?

Thanks