package bzgorm

import "fmt"

func WithLeftJoin(table, tableJoinField, mainTableField string) string {
	return WithJoin("LEFT", table, tableJoinField, mainTableField)

}

func WithRightJoin(table, tableJoinField, mainTableField string) string {
	return WithJoin("RIGHT", table, tableJoinField, mainTableField)
}

func WithJoin(typ, table, tableJoinField, mainTableField string) string {
	return fmt.Sprintf("%s JOIN %s ON %s.%s = %s", typ, table, table, tableJoinField, mainTableField)
}