| PHP |
|---|
|
public static function SQLColumns(string $tableName , LJCDbColumns $sqlColumns, bool $includeParens = false , LJCJoins $joins = null) : string |
| PHP |
|---|
include_once "LJCRoot.php";
$prefix = RelativePrefix();
include_once "$prefix/LJCPHPCommon/LJCDataManagerLib.php";
include_once "$prefix/LJCPHPCommon/LJCDBAccessLib.php";
$joins = new LJCJoins();
$join = $joins->Add("JoinTableName");
$join->JoinOns->Add("FromColumnName", "ToColumnName");
$join->Columns->Add("JoinColumnName", "PropertyName", "ResultName");
$tableName = "TableName";
$dbColumns = new DbColumns();
$dbColumns->Add("ID", dataTypeName: "int");
$dbColumns->Add("Name");
$columns = LJCSQLBuilder::SQLColumns($tableName, $dbColumns, $joins);
// $columns =
// TableName.ID,
// TableName.Name,
// JoinTableName.JoinColumnName as ResultName
|