CODEWITHSUNDEEP
postgresqlselectdynamic
Bhavik Ambani
Bhavik Ambani

Reputation: 6657

Combine dynamic columns with select query

I am using a PostgreSQL database. I have one select query:

select userid, name, age from tbluser;

Now there is another table, tblcalculatedtax, which is generated on the fly and their column names are not predefined, the only mapping between that table and this table is userid. I want to get records after joining two tables. How can I get that?

Upvotes: 0

Views: 350

Answers (2)

Erwin Brandstetter
Erwin Brandstetter

Reputation: 659207

Simpler:

SELECT *
FROM   tbluser 
JOIN   tblcalculatedtax USING (userid)

Details in the fine manual about SELECT.

Upvotes: 1

craigmj
craigmj

Reputation: 5077

Your need SQL Joins. Here's a W3Schools tutorial: http://www.w3schools.com/sql/sql_join.asp

To quickly answer your question, though:

SELECT * FROM tbluser 
  INNER JOIN tblcalculatedtax 
  ON tbluser.userid=tblcalculatedtext.userid

The * selects all the columns, so you don't need to know their names. Of course, I'm not sure what use a column is to you if you don't know it's name: do you know what data it contains?

Upvotes: 1

Related Questions