Hi All
im trying to do a select that will return me the JOIN result appended in one
row per user_id and not in multi columns.
Is it possible ?
user_id | username | pet_type | pet_name | pet_type | pet_name |
1 | BH | dog | Garfield | cat |
Garfield |
CREATE TABLE users (
user_id SERIAL PRIMARY KEY,
username VARCHAR(10)
)
CREATE TABLE users_prop (
user_id INT4 REFERENCES users ON UPDATE CASCADE ON DELETE CASCADE,
pet_type VARCHAR(10),
pet_name VARCHAR(10)
)
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------