Gorm How join pass table name parameter in sql builder

Your Question

How join pass table name parameter in sql builder

Example:

Db.Table("prefix_"+"tablenameA").
            Joins("LEFT JOIN ? ON ?.id = ?.post_id",
                "prefix_"+"tablenameB",
                "prefix_"+"tablenameA",
                "prefix_"+"tablenameB",
            )

result:

You have an error in your SQL syntax;
 LEFT JOIN 'xx_tablenameB' ON 'xx_tablenameA'.id = 'xx_tablenameB'.post_id

i need

 LEFT JOIN `xx_tablenameB` ON `xx_tablenameA`.id = `xx_tablenameB`.post_id

The document you expected this should be explained

JOINS

Expected answer

Comment From: a631807682

Similar to https://github.com/go-gorm/gorm/issues/5170 Relpace raw sql yourself

Comment From: benzdeus

OK thank bro. solution fmt.sprintf then sql command