xxsteambroxx
Benutzer
- Beiträge
- 5
Ist eine Abfrage wie diese Möglich? Ich will einen bestimmten Namen eingeben z. B. Nico (anstelle von xyz) und will dann alle Einträge ausgegeben bekommen die dieses Wort enthalten.
SELECT N.TEXT_FIELD, P.ID, P.FIRST_NAME, P.LAST_NAME, Z.PLZ, Z.CITY_NAME, L.LANGUAGE_NAME, L.LANGUAGE_KNOWLEDGE from NICO_GUESTBOOK N
INNER JOIN NICO_PERSON P ON P.ID = N.PERSON_ID
INNER JOIN NICO_LANGUAGE L ON L.ID = P.LANGUAGE_ID
INNER JOIN NICO_ZIPCODE Z ON Z.ID = P.ZIPCODE_ID
WHERE P.LAST_NAME = 'xyz'
OR P.FIRST_NAME = 'xyz'
OR Z.PLZ = 'xyz'
OR Z.CITY_NAME = 'xyz'
OR L.LANGUGE_NAME = 'xyz'
OR L.LANGUAGE_KNOWLEDGE = 'xyz'
mit Freundlichen Grüßen
SteamBro
SELECT N.TEXT_FIELD, P.ID, P.FIRST_NAME, P.LAST_NAME, Z.PLZ, Z.CITY_NAME, L.LANGUAGE_NAME, L.LANGUAGE_KNOWLEDGE from NICO_GUESTBOOK N
INNER JOIN NICO_PERSON P ON P.ID = N.PERSON_ID
INNER JOIN NICO_LANGUAGE L ON L.ID = P.LANGUAGE_ID
INNER JOIN NICO_ZIPCODE Z ON Z.ID = P.ZIPCODE_ID
WHERE P.LAST_NAME = 'xyz'
OR P.FIRST_NAME = 'xyz'
OR Z.PLZ = 'xyz'
OR Z.CITY_NAME = 'xyz'
OR L.LANGUGE_NAME = 'xyz'
OR L.LANGUAGE_KNOWLEDGE = 'xyz'
mit Freundlichen Grüßen
SteamBro