Superheld
9/21/2018 - 7:33 AM

SQL Select auf Mutter und Kind

SQL
content_copyfile_download
stmt = g_dbQuery.prepare(conn, "SELECT STR_COURSE,STR_INSTITUTION,STR_ROLE,STR_TIMEZONE FROM DATAGROUP('E9FCDEC5E1228A9C752CBF29803396B826B123A3') k, DATAGROUP('AF6A8864A7BD0CE2F5EADF4E47033F9B59E4C970') m  WHERE m.strid=k.fkstrid AND m.STR_VKORG=? and k.STR_GROUP=?")

	stmt.setString(1, strVkorg)
	stmt.setString(2, strGroup)

	rs = stmt.executeQuery()

	while (rs.next())
	{
		strCourse1 = rs.getStringValue(1)
		strInstitution = rs.getStringValue(2)
		strRole1 = rs.getStringValue(3)
		strTimezone = rs.getStringValue(4)

	}