我有一个填充临时表的存储过程。使用多个动态SQL填充临时表(它具有"having“和"between”子句)。我在我的存储过程中使用以下命令执行此SQL:
set @sql = concat("insert into my_temp select * from my_table where my_date betweenprepared dynamic statemen
让我澄清一下,我的问题是“如何从绑定单个表和交叉引用表中选择行而不重复值?”║ cook ║╚═══════════════╩═══════════════╝$sql= "SELECT jobs.details, positions.name AS position FROM jobs
INNER JOIN job2pos ON jobs.job_id = job2pos.job_id[position]