I am a beginner in PostgreSQL and I need to make a INNER JOIN
to relate data from two tables. It took me a long time to figure this out from FOREIGN KEY
, but I made the right reference in the database. Now, I have a C # application and I'm not sure how I should write the table read command and data relation.
The current command structure follows:
SELECT * FROM users_data WHERE user_id = {0}
What leaves me in doubt is where to put INNER JOIN
, AS
, and ON
. The users_data
table has a user_type
column and this value must be toggled with the users_type
table.