Assuming I have 2 tables:
Persons: ID, Name
Pets: PName
I want to select all the IDs from Persons and assign each one with a different PName or NULL if there are more IDs.
Basically it looks like a simple select query from Persons and then somehow append a select query from Pets but I'm not sure how to do that. I tried to use JOIN and UNION but none of them gave me exactly what I wanted.
Aucun commentaire:
Enregistrer un commentaire