All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql.auth.secFirm.read.sql Maven / Gradle / Ivy

There is a newer version: 1.0.31
Show newest version
SELECT distinct
	sf.active,
	sf.theme,
	sf.firmId,
	sf.firmName,
	sf.contactName,
	sf.contactPhone,
	sf.creationDate,
	sf.attributes,
	sf.revNo,
	sf.stamp,
	sf.userId
FROM
	secFirm sf
inner join (__authDataSql__) d on
	d.dataType = 'firm' and
	(d.d1 = '*' or d.d1 = sf.firmId)
WHERE
	sf.firmId = :firmId




© 2015 - 2025 Weber Informatics LLC | Privacy Policy